Systems and methods for reflexive questionnaire generation

ABSTRACT

Provided methods and systems allow dynamic rendering of a reflexive questionnaire based on a modifiable spreadsheet for users with little to no programming experience and knowledge. Some methods comprise receiving a modifiable spreadsheet with multiple rows, each row comprising rendering instructions for a reflexive questionnaire from a first computer, such as a data type cell, statement cell, logic cell, and a field identifier; rendering a graphical user interface, on a second computer, comprising a label and an input element corresponding to the rendering instructions of a first row of the spreadsheet; receiving an input from the second computer; evaluating the input against the logic cell of the spreadsheet; in response to the input complying with the logic cell of the spreadsheet, dynamically rendering a second label and a second input element to be displayed on the graphical user interface based on the logic of the first row.

CROSS-REFERENCE TO RELATED PATENT APPLICATIONS

This patent application claims a benefit of priority to U.S. ProvisionalPatent Application Ser. No. 62/798,070, filed on Jan. 29, 2019; U.S.Provisional Patent Application Ser. No. 62/798,076, filed on Jan. 29,2019; U.S. Provisional Patent Application Ser. No. 62/798,089, filed onJan. 29, 2019; and U.S. Provisional Patent Application Ser. No.62/798,099, filed on Jan. 29, 2019, each of which is incorporated byreference herein for all purposes.

TECHNICAL FIELD

Generally, this disclosure relates to computing. More particularly, thisdisclosure relates to software coding and dynamic rendering of graphicaluser interfaces.

BACKGROUND

Data intake forms (e.g., questionnaires) may provide an interactivecellular interface for data intake and processing. Online questionnairescan be locally run or network-based. The questionnaires can contain asingle worksheet or a plurality of worksheets, whether related orunrelated to each other in content or form. As the processing power ofcomputers allow for greater computer functionality and the Internettechnology era allows for interconnectivity between computing systems,many institutions rely on online questionnaires to receive data fromusers and potential clients. However, new technical challenges have beenidentified. For example, conventional software solutions utilize astatic method to display data intake questionnaires by rendering thequestionnaires based on existing code (e.g., code stored within aninternal or an external database). To combat this problem, many existingsoftware solutions have attempted to dynamically render thequestionnaires by allowing an employee to update and/or modify thecorresponding code. However, this method requires the employees to befamiliar with complex coding algorithms; this task has been provendifficult because most employees have little or no software programmingknowledge. For example, an employee must be familiar with XML or HTML inorder to modify the code and to customize the data intake questionnaire.The technical challenges become more challenging if the network page(displaying the questionnaire) should contain a set of labels and a setof fields, both of which would dynamically change in real-time, whetherin content or type, based on a set of user inputs into the set offields. The technical challenges become even more challenging if the setof labels must precisely match a preexisting content output, such as apaper document or an electronic document. The technical challengesbecome yet even more challenging if a file should be generated based onthe set of user inputs.

Furthermore, many data intake questionnaires are associated withsensitive data, such as medical or personal data. These data intakesquestionnaires may be regulated by various state and/or federal laws.For example, several federal and/or state laws require variousdisclaimers to be displayed based upon a potential client's responses tocertain questions. Conventional online questionnaires display all thedisclaimers associated with the data intake (whether relevant to thepotential client's responses or not). These disclaimers are complicated,wordy, and confusing; therefore, conventional solutions create anegative user experience by “crowding” the graphical user interfaceprovided to the potential clients. Some disclaimers are oftenunnecessary and not-applicable to all users. However, conventionalsoftware solutions usually include all the relevant disclaimers becausemodifying the code that controls the rendering of the graphical userinterface is too burdensome and technically challenging. Moreover, manyentities are not willing to risk allowing employees to modify the codebecause the employees (e.g., field agents) typically do not have properprogramming experience and knowledge.

Additionally, storage of completed questionnaires in Portable DocumentFormat (PDF) files may be inefficient since some PDF files may bedifficult to work with or limited in functionality. Moreover, whenserving questionnaires that involve querying various data sources forinformational validation and thoroughness, then various datasets fromthe data sources may not be properly formatted and may includeduplicates. Further, programming questionnaires may be time-consumingand laborious when various programming logic is not modular or reusable.Also, there are situations when various users of various demographicbackgrounds access various websites, yet same or similar processingrules may apply to those websites. However, those websites may not beprogrammed to enable application of same or similar processing rules.

SUMMARY

For the aforementioned reasons, there is a need for an accurate andefficient computer-implemented system and method for dynamicallygenerating and rendering an online data intake questionnaire, which isconfigured to be modified by a person with a minimal knowledge ofprogramming. This disclosure at least partially addresses at least oneof the above challenges. However, this disclosure can prove useful toother technical areas. Therefore, at least some claims should not beconstrued as necessarily limited to addressing any of the abovechallenges.

In an embodiment, a computer-implemented method comprises receiving, bya server, from a first computing device, a first file comprising aspreadsheet, wherein the spreadsheet comprises at least a first row anda second row, wherein the first row comprises a first statement cellcomprising a first statement, a first data type cell comprising a firstdata type identifier, a first logic cell comprising a first logic, and afirst field cell comprising a first field identifier, wherein the secondrow comprises a second statement cell comprising a second statement, asecond data type cell comprising a second data type identifier, a secondlogic cell comprising a second logic, and a second field cell comprisinga second field identifier; dynamically rendering, by the server, agraphical user interface configured to be displayed on a secondcomputing device, wherein the graphical user interface comprises a firstlabel and a first input element, wherein the first label comprises thefirst statement sourced from and corresponding to the first statementcell, wherein the first input element is configured for a first inputaccording to the first data type identifier sourced from andcorresponding to the first data type cell; in response to receiving, bythe server, the first input from the second computing device:evaluating, by the server, the first input against the first logic, andin response to the first input corresponding to the first logic:dynamically rendering, by the server, a second label and a second inputelement to be displayed on the graphical user interface, wherein thesecond label comprises the second statement sourced from andcorresponding to the second statement cell, and wherein the second inputelement is configured for a second input according to the second datatype identifier sourced from and corresponding to the second data typecell; and in response to receiving, by the server, the second input:evaluating, by the server, the second input against the second logic,and in response to the second input corresponding to the second logic:generating, by the server, a second file, wherein the server inserts thefirst input into a first field of the second file based on the firstfield identifier and inserts the second input into a second field of thesecond file based on the second field identifier; and transmitting, bythe server, the second file comprising the first input and the secondinput to the first computing device.

In another embodiment, a computer system comprises a server, which isconfigured to a server configured to: receive, from a first computingdevice, a first file comprising a spreadsheet, wherein the spreadsheetcomprises at least a first row and a second row, wherein the first rowcomprises a first statement cell comprising a first statement, a firstdata type cell comprising a first data type identifier, a first logiccell comprising a first logic, and a first field cell comprising a firstfield identifier, wherein the second row comprises a second statementcell comprising a second statement, a second data type cell comprising asecond data type identifier, a second logic cell comprising a secondlogic, and a second field cell comprising a second field identifier;dynamically render a graphical user interface configured to be displayedon a second computing device, wherein the graphical user interfacecomprises a first label and a first input element, wherein the firstlabel comprises the first statement sourced from and corresponding tothe first statement cell, wherein the first input element is configuredfor a first input according to the first data type identifier sourcedfrom and corresponding to the first data type cell; in response toreceiving the first input from the second computing device: evaluate thefirst input against the first logic, and in response to the first inputcorresponding to the first logic: dynamically render a second label anda second input element to be displayed on the graphical user interface,wherein the second label comprises the second statement sourced from andcorresponding to the second statement cell, and wherein the second inputelement is configured for a second input according to the second datatype identifier sourced from and corresponding to the second data typecell; and in response to receiving the second input: evaluate the secondinput against the second logic, and in response to the second inputcorresponding to the second logic: generate a second file, wherein theserver inserts the first input into a first field of the second filebased on the first field identifier and inserts the second input into asecond field of the second file based on the second field identifier;and transmit the second file comprising the first input and the secondinput to the first computing device.

In another embodiment, a computer-implemented method comprisesreceiving, by a server, from a first computing device, a renderingrequest comprising a request to render a graphical user interfacedisplayed on a second computing device; querying, by the server, adatabase to retrieve a spreadsheet associated with the graphical userinterface, wherein the spreadsheet comprises at least a first row and asecond row, wherein the first row comprises a first statement cellcomprising a first statement, a first data type cell comprising a firstdata type identifier, a first logic cell comprising a first logic, and afirst field cell comprising a first field identifier, wherein the secondrow comprises a second statement cell comprising a second statement, asecond data type cell comprising a second data type identifier, a secondlogic cell comprising a second logic, and a second field cell comprisinga second field identifier; upon retrieving the spreadsheet, dynamicallyrendering, by the server, the graphical user interface on the secondcomputing device, wherein the graphical user interface comprises a firstlabel and a first input element, wherein the first label comprises thefirst statement sourced from and corresponding to the first statementcell, wherein the first input element is configured for a first inputaccording to the first data type identifier sourced from andcorresponding to the first data type cell; upon displaying the firstlabel, receiving, by the server, a first input from the second computingdevice; in response to receiving the first input: evaluating, by theserver, the first input against the first logic, and in response to thefirst input corresponding to the first logic: dynamically rendering, bythe server, a second label and a second input element to be displayed onthe graphical user interface, wherein the second label comprises thesecond statement sourced from and corresponding to the second statementcell, and wherein the second input element is configured for a secondinput according to the second data type identifier sourced from andcorresponding to the second data type cell; and in response toreceiving, by the server, the second input: evaluating, by the server,the second input against the second logic.

In another embodiment, a computer system comprises a server, which isconfigured to: receive from a first computing device, a renderingrequest comprising a request to render a graphical user interfacedisplayed on a second computing device; query a database to retrieve aspreadsheet associated with the graphical user interface, wherein thespreadsheet comprises at least a first row and a second row, wherein thefirst row comprises a first statement cell comprising a first statement,a first data type cell comprising a first data type identifier, a firstlogic cell comprising a first logic, and a first field cell comprising afirst field identifier, wherein the second row comprises a secondstatement cell comprising a second statement, a second data type cellcomprising a second data type identifier, a second logic cell comprisinga second logic, and a second field cell comprising a second fieldidentifier; upon retrieving the spreadsheet, dynamically render thegraphical user interface on the second computing device, wherein thegraphical user interface comprises a first label and a first inputelement, wherein the first label comprises the first statement sourcedfrom and corresponding to the first statement cell, wherein the firstinput element is configured for a first input according to the firstdata type identifier sourced from and corresponding to the first datatype cell; upon displaying the first label, receive a first input fromthe second computing device; in response to receiving the first input:evaluate the first input against the first logic, and in response to thefirst input corresponding to the first logic: dynamically render asecond label and a second input element to be displayed on the graphicaluser interface, wherein the second label comprises the second statementsourced from and corresponding to the second statement cell, and whereinthe second input element is configured for a second input according tothe second data type identifier sourced from and corresponding to thesecond data type cell; and in response to receiving the second input:evaluate the second input against the second logic.

In another embodiment, a computer-implemented method comprisesretrieving, by a server, a file comprising a spreadsheet, wherein thespreadsheet comprises at least a parent worksheet, wherein the parentworksheet comprises a first row, wherein the first row comprises a firststatement cell comprising a first statement, a first data type cellcomprising a first data type identifier, and a first logic cellcomprising a first logic; in response to receiving, by the server, arendering request from a first client computing device, generating, bythe server, a child worksheet in the spreadsheet, wherein the childworksheet comprises a second row, wherein the second row inherits thefirst row such that the second row comprises a second statement cellcorresponding to the first statement, a second data type cellcorresponding to the first data type identifier, and a second logic cellcorresponding to the first logic; receiving, by the server, from thefirst client computing device, a modification request to modify at leastone of the first statement in the second statement cell, the first datatype identifier in the second data type cell, and the first logic in thesecond logic cell, wherein the modification request comprises amodification input; modifying, by the server, at least one of the firststatement in the second statement cell, the first data type identifierin the second data type cell, or the first logic in the second logiccell in the child worksheet based on the modification input; uponmodifying the child worksheet, rendering, by the server, on a secondclient computing device, a graphical user interface corresponding to themodified child worksheet

In another embodiment, a computer system comprises a server, which isconfigured to retrieve a file comprising a spreadsheet, wherein thespreadsheet comprises at least a parent worksheet, wherein the parentworksheet comprises a first row, wherein the first row comprises a firststatement cell comprising a first statement, a first data type cellcomprising a first data type identifier, and a first logic cellcomprising a first logic; in response to receiving a rendering requestfrom a first client computing device, generate a child worksheet in thespreadsheet, wherein the child worksheet comprises a second row, whereinthe second row inherits the first row such that the second row comprisesa second statement cell corresponding to the first statement, a seconddata type cell corresponding to the first data type identifier, and asecond logic cell corresponding to the first logic; receive from thefirst client computing device, a modification request to modify at leastone of the first statement in the second statement cell, the first datatype identifier in the second data type cell, and the first logic in thesecond logic cell, wherein the modification request comprises amodification input; modify at least one of the first statement in thesecond statement cell, the first data type identifier in the second datatype cell, or the first logic in the second logic cell in the childworksheet based on the modification input; upon modifying the childworksheet, render on a second client computing device, a graphical userinterface corresponding to the modified child worksheet.

In another embodiment, a computer-implemented method comprisesdisplaying, by a server, a first graphical user interface to a firstclient, wherein the first graphical user interface comprises a check-outelement configured for a check-out input related to a file and acheck-in element configured for a check-in input related to the file,wherein the file comprises at least one spreadsheet, wherein thespreadsheet comprises at least one row, wherein the at least one rowcomprises a statement cell comprising a statement, a data type cellcomprising a data type identifier, and a logic cell comprising a logic;in response to receiving, by the server, the check-out input from thefirst client, checking-out, by the server, the file such that the filecannot be modified by a second client until the server receives thecheck-in input from the first client; receiving, by the sever, from thefirst client, a write request associated with the checked-out file and awrite input associated with the write request; modifying, by the server,at least one of the statement, the data type identifier, or the logicbased on the write request and the write input from the first client; inresponse to receiving, by the server, the check-in input from the firstclient after the modification, checking-in, by the server, the file suchthat the file can be modified by the second client; generating, by theserver, a set of rendering instructions corresponding to a secondgraphical user interface based on the spreadsheet such that the secondgraphical user interface comprises a label and an input element, whereinthe label comprises the statement as modified, wherein the input elementis configured for an input based on the data type identifier asmodified; and transmitting, by the server, the set of renderinginstructions to a computing device associated with a third client,whereby the set of rendering instructions causes the computing deviceassociated with the third client to display the second graphical userinterface.

In another embodiment, a computer system comprises a server, which isconfigured to display a first graphical user interface to a firstclient, wherein the first graphical user interface comprises a check-outelement configured for a check-out input related to a file and acheck-in element configured for a check-in input related to the file,wherein the file comprises at least one spreadsheet, wherein thespreadsheet comprises at least one row, wherein the at least one rowcomprises a statement cell comprising a statement, a data type cellcomprising a data type identifier, and a logic cell comprising a logic;in response to receiving the check-out input from the first client,check-out the file such that the file cannot be modified by a secondclient until the server receives the check-in input from the firstclient; receive from the first client, a write request associated withthe checked-out file and a write input associated with the writerequest; modify at least one of the statement, the data type identifier,or the logic based on the write request and the write input from thefirst client; in response to receiving the check-in input from the firstclient after the modification, check-in the file such that the file canbe modified by the second client; generate a set of renderinginstructions corresponding to a second graphical user interface based onthe spreadsheet such that the second graphical user interface comprisesa label and an input element, wherein the label comprises the statementas modified, wherein the input element is configured for an input basedon the data type identifier as modified; and transmit the set ofrendering instructions to a computing device associated with a thirdclient, whereby the set of rendering instructions causes the computingdevice associated with the third client to display the second graphicaluser interface.

In another embodiment, a method comprising: presenting, by a server, afirst user interface to a first client, wherein the first user interfaceis configured to receive a set of logic and a version identifier fromthe first client; populating, by the server, a spreadsheet with the setof logic and the version identifier; executing, by the server, the setof logic from the spreadsheet; presenting, by the server, a second userinterface to a second client, wherein the second user interface containsa reflexive questionnaire with a set of questions generated based on theset of logic; storing, by the server, the set of questions such that theset of questions is associated with the version identifier; receiving,by the server, a set of answers to the set of questions from the secondclient; storing, by the server, the set of answers as a set of metadata;associating, by the server, the version identifier with the set ofmetadata; presenting, by the server, a third user interface to a thirdclient, wherein the third user interface is configured to receive arequest from the third client; receiving, by the server, the requestfrom the third client; locating, by the server, the version identifierresponsive to the request; retrieving, by the server, the set ofquestions based on the version identifier; retrieving, by the server,the set of metadata based on the version identifier; recreating, by theserver, the reflexive questionnaire with the set of questions based onthe version identifier and the set of answers based on the set ofmetadata responsive to the request; presenting, by the server, thereflexive questionnaire on the third user interface to the third clientresponsive to the request.

In another embodiment, a system comprising: a server configured to:present a first user interface to a first client, wherein the first userinterface is configured to receive a set of logic and a versionidentifier from the first client; populate a spreadsheet with the set oflogic and the version identifier; execute the set of logic from thespreadsheet; present a second user interface to a second client, whereinthe second user interface contains a reflexive questionnaire with a setof questions generated based on the set of logic, store the set ofquestions such that the set of questions is associated with the versionidentifier; receive a set of answers to the set of questions from thesecond client; store the set of answers as a set of metadata; associatethe version identifier with the set of metadata; present a third userinterface to a third client, wherein the third user interface isconfigured to receive a request from the third client; receive therequest from the third client; locate the version identifier responsiveto the request; retrieve the set of questions based on the versionidentifier; retrieve the set of metadata based on the versionidentifier; recreate the reflexive questionnaire with the set ofquestions based on the version identifier and the set of answers basedon the set of metadata responsive to the request; present the reflexivequestionnaire on the third user interface to the third client responsiveto the request.

In another embodiment, a method comprising: presenting, by a server, afirst user interface to a first client, wherein the first user interfaceis configured to receive a format logic, a semantic logic, and adeduplication logic from the client; receiving, by the server, theformat logic, the semantic logic, and the deduplication logic from thefirst client; storing, by the server, the format logic, the semanticlogic, and the deduplication logic in a data structure; presenting, bythe server, a second user interface to a second client, wherein thesecond user interface is configured to receive a set of rules from thesecond client; receiving, by the server, the set of rules from thesecond client; populating, by the server, a spreadsheet with the set ofrules; executing, by the server, the set of rules from the spreadsheet;presenting, by the server, a third user interface to a third client,wherein the third user interface includes a reflexive questionnaireincluding a set of questions generated based on the set of rules;sending, by the server, a query to a data source as the reflexivequestionnaire is presented on the third user interface, wherein thequery is triggered based on the set of rules, wherein the data source isremote from the server; receiving, by the server, a result to the queryfrom the data source; translating, by the server, the result based onthe format logic, the semantic logic, and the deduplication logic fromthe data structure; updating, by the server, the reflexive questionnairebased on the result as translated; receiving, by the server, a set ofanswers to the questions from the third client based on the reflexivequestionnaire as updated; storing, by the server, the set of answers ina database record; evaluating, by the server, the set of answers in thedatabase record against a threshold; marking, by the server, thedatabase record as satisfying the threshold based on the set of answerssatisfying the threshold, otherwise, marking, by the server, thedatabase record as not satisfying the threshold based on the set ofanswers not satisfying the threshold.

In another embodiment, a system comprising: a server configured to:present a first user interface to a first client, wherein the first userinterface is configured to receive a format logic, a semantic logic, anda deduplication logic from the client; receive the format logic, thesemantic logic, and the deduplication logic from the first client; storethe format logic, the semantic logic, and the deduplication logic into adata structure; present a second user interface to a second client,wherein the second user interface is configured to receive a set ofrules from the second client; receive the set of rules from the secondclient; populate a spreadsheet with the set of rules; execute the set ofrules from the spreadsheet; present a third user interface to a thirdclient, wherein the third user interface includes a reflexivequestionnaire including a set of questions generated based on the set ofrules; send a query to a data source as the reflexive questionnaire ispresented on the third user interface, wherein the query is triggeredbased on the set of rules, wherein the data source is remote from theserver; receive a result to the query from the data source; translatethe result based on the format logic, the semantic logic, and thededuplication logic from the data structure; update the reflexivequestionnaire based on the result as translated; receive a set ofanswers to the questions from the third client based on the reflexivequestionnaire as updated; store the set of answers in a database record;evaluate the set of answers in the database record against a threshold;mark the database record as satisfying the threshold based on the set ofanswers satisfying the threshold, otherwise, marking, by the server, thedatabase record as not satisfying the threshold based on the set ofanswers not satisfying the threshold.

In another embodiment, a method comprising: presenting, by a server, afirst spreadsheet to a first client; populating, by the server, thefirst spreadsheet with a first set of logic received from the firstclient; assigning, by the server, a name to the first spreadsheetcontaining the first set of logic; enabling, by the server, the name tobe shared with a second client; populating, by the server, a secondspreadsheet with a second set of logic received from the second client,wherein the second set of logic contains the name; executing, by theserver, the second set of logic from the second spreadsheet such thatthe first set of logic is called based on the name and executed based onthe name; presenting, by the server, a user interface to a third client,wherein the user interface contains a reflexive questionnaire includinga set of questions generated based on the second set of logic inclusiveof calling the first set of logic; receiving, by the server, a set ofanswers to the set of questions from the third client; storing, by theserver, the set of answers in a database record; evaluating, by theserver, the set of answers in the database record against a threshold;marking, by the server, the database record as satisfying the thresholdor not satisfying the threshold based on the set of answers satisfyingthe threshold or not satisfying the threshold respectively.

In another embodiment, a system comprising: a server configured to:present a first spreadsheet to a first client; populate the firstspreadsheet with a first set of logic received from the first client;assign a name to the first spreadsheet containing the first set oflogic; enable the name to be shared with a second client; populate asecond spreadsheet with a second set of logic received from the secondclient, wherein the second set of logic contains the name; execute thesecond set of logic from the second spreadsheet such that the first setof logic is called based on the name and executed based on the name;present a user interface to a third client, wherein the user interfacecontains a reflexive questionnaire including a set of questionsgenerated based on the second set of logic inclusive of calling thefirst set of logic; receive a set of answers to the set of questionsfrom the third client; store the set of answers in a database record;evaluate the set of answers in the database record against a threshold;mark the database record as satisfying the threshold or not satisfyingthe threshold based on the set of answers satisfying the threshold ornot satisfying the threshold respectively.

In another embodiment, a method comprising: presenting, by a server, aspreadsheet to a client, wherein the spreadsheet is configured toreceive a plurality of logic rules for a plurality of web pagesassociated with a plurality of domain names, wherein the domain namesare different from each other; receiving, by the server, the logic rulesfrom the client; populating, by the server, the spreadsheet with thelogic rules; executing, by the server, the logic rules from thespreadsheet; presenting, by the server, a plurality of reflexivequestionnaires on the web pages associated with the domain names as theweb pages are accessed by a plurality of browsers, wherein the reflexivequestionnaires include a plurality of questions generated based on thelogic rules; receiving, by the server, a plurality of answers to thequestions from the browsers; storing, by the server, the answers in aplurality of database records; evaluating, by the server, the answers inthe database records against a threshold; marking, by the server, thedatabase records as satisfying the threshold or not satisfying thethreshold based on the answers satisfying the threshold or notsatisfying the threshold respectively.

In another embodiment, a system comprising: a server configured to:present a spreadsheet to a client, wherein the spreadsheet is configuredto receive a plurality of logic rules for a plurality of web pagesassociated with a plurality of domain names, wherein the domain namesare different from each other; receive the logic rules from the client;populate the spreadsheet with the logic rules; execute the logic rulesfrom the spreadsheet; present a plurality of reflexive questionnaires onthe web pages associated with the domain names as the web pages areaccessed by a plurality of browsers, wherein the reflexivequestionnaires include a plurality of questions generated based on thelogic rules; receive a plurality of answers to the questions from thebrowsers; store the answers in a plurality of database records; evaluatethe answers in the database records against a threshold; mark thedatabase records as satisfying the threshold or not satisfying thethreshold based on the answers satisfying the threshold or notsatisfying the threshold respectively.

Additional features and advantages of various embodiments are set forthin a detailed description that follows. Various objectives and otheradvantages of this disclosure are realized and attained by variousstructures particularly pointed out in various exemplary embodiments inthe detailed description and claims hereof as well as in a set ofappended drawings. Note that the detailed description is exemplary andexplanatory and is intended to provide further explanation of thisdisclosure as claimed.

DESCRIPTION OF DRAWINGS

The accompanying drawings constitute a part of this specification andillustrate an embodiment of the present disclosure and together with thespecification, explain the present disclosure.

FIG. 1 shows a schematic view of an embodiment of a network topologyaccording to the present disclosure.

FIG. 2 shows a flowchart of an embodiment of a process for filegeneration according to the present disclosure.

FIG. 3 shows a flowchart of an embodiment of a process for cellprocessing according to the present disclosure.

FIG. 4 shows a flowchart of an embodiment of a process for inheritancebased data structure generation according to the present disclosure.

FIG. 5 shows a flowchart of an embodiment of a first process fordocument management according to the present disclosure.

FIG. 6 shows a flowchart of an embodiment of a second process fordocument management according to the present disclosure.

FIGS. 7A-B show a screenshot of an embodiment of a spreadsheetcontaining a parent worksheet being active for data input as selectedvia a parent worksheet tab and a child worksheet being inactive for datainput as not selected via a child worksheet tab according to the presentdisclosure.

FIG. 7C shows a screenshot of an embodiment of a network pagedynamically generated based on a parent worksheets of FIGS. 7A-Baccording to the present disclosure.

FIG. 8A shows a screenshot of an embodiment of a spreadsheet containinga parent worksheet being inactive for data input as not selected via aparent worksheet tab and a child worksheet being active for data inputas selected via a child worksheet tab according to the presentdisclosure.

FIG. 8B shows a screenshot of an embodiment of a network pagedynamically generated based on a parent worksheet of FIG. 8A accordingto the present disclosure.

FIG. 9 shows a screenshot of an embodiment of a single network pagegenerated based on a spreadsheet according to the present disclosure.

FIG. 10 shows an embodiment of a table of reflexive questions and rules,where the reflexive questions appear in a dynamically adjusted networkpage based on the rules, where the rules determine when a question willor will not be asked according to the present disclosure.

FIG. 11 shows a flowchart of an embodiment of a process ofreconstructing a reflexive questionnaire based on a set of metadataaccording to the present disclosure.

FIG. 12 shows a flowchart of an embodiment of a process of querying adata source during a presentation of a reflexive questionnaire with aset of questions generated based on a logic contained with a spreadsheetaccording to the present disclosure.

FIG. 13 shows a flowchart of an embodiment of a process of modularizinglogic statements in a spreadsheet according to the present disclosure.

FIG. 14 shows a flowchart of an embodiment of a method for presenting aplurality of reflexive questionnaires on a plurality of web pages havinga plurality of domain names assigned thereto according to thisdisclosure.

DETAILED DESCRIPTION

This disclosure more fully references to the accompanying drawings, inwhich various embodiments of this disclosure are shown. This disclosuremay, however, be embodied in many different forms and should not beconstrued as necessarily being limited to the embodiments disclosedherein. Rather, these embodiments are provided so that the presentdisclosure is thorough and complete, and fully conveys the concepts ofthe present disclosure to those skilled in the relevant art.

As described herein, various disclosed technologies can be implementedvia a plurality of computers (servers/clients) utilizing a plurality ofdata structures/messages. Such implementations include datastructure/message generation/formation, storage, retrieval, population,copying, moving, editing, modifying, sorting, searching, sending,receiving, updating, deleting, encrypting, decrypting, de-duplicating,converting, uploading, downloading, or any other local or network-baseddata structure/message operation associated with a structure/message(data shell) or the data itself (content). For example, thestructure/message (shell) can comprise a file, a table, a spreadsheet,an array, a matrix, a linked list, a tree, a string, a quadtree, astack, a deck, or any other structures of data. For example, aspreadsheet can be stored within a file. The data (content) can containany alphanumeric, image, acoustic, binary, symbolic, equation, formula,or any other content. For example, a spreadsheet can comprise the data(content). Also, note that various disclosed algorithms are somenon-limiting examples and other variations are possible.

FIG. 1 shows a schematic view of an embodiment of a network topologyaccording to the present disclosure. A topology 100 comprises a widearea network (WAN) 102 to which a plurality of equipment segments arecoupled, whether directly or indirectly, whether in a wired or wirelessmanner. The segments include a first segment and a second segment.

The first segment is operated via a first operator and the secondsegment is operated via a second operator. The first segment comprises arouter 104, a firewall 106, a network server 108, a firewall 110, anapplication server 112, a database server 114, a local area network(LAN) 116, a workstation 118, an administrator terminal 120, and amultifunction device 122.

The second segment comprises a client computing device 124 communicablycoupled to the WAN 102, whether directly or indirectly, whether in awired or a wireless manner. The client computing device 124 is operatedby an end user, such as a potential or an actual service providercustomer. In some embodiments, the first operator and the secondoperator are a single operator, such as for testing or maintenance of atleast one of the first segment or the second segment.

The topology 100 is based on a distributed network operation model,which allocates tasks/workloads between servers, which provide aresource/service, and clients, which request the resource/service.Although the servers and the clients illustrate differentcomputers/applications, in some embodiments, the servers and the clientsreside in or share or are one system/application. Further, the topology100 entails allocating a large number of resources to a small number ofservers, where complexity of the clients, depends on how muchcomputation is offloaded to the small number of servers, i.e., morecomputation offloaded from the clients onto the servers leads to lighterclients, such as being more reliant on network sources and less relianton local computing resources. However, note that other computing modelsare possible as well. For example, such models can comprisedecentralized computing, such as peer-to-peer (P2P), for instanceBit-Torrent, or distributed computing, such as via a computer clusterwhere a set of networked computers works together such that the computercan be viewed as a single system. For example, a communication maycomprise sending a request to open a network port for access or abrowsing request or a packet request or a page request or a file requestor a record request.

Each component of the topology 100 can be implemented in a logic,whether hardware-based or software-based. For example, when the logic ishardware-based, then such logic can comprise circuitry, such asprocessors, memory, input devices, output devices, or other hardware,that is configured, such as via programming or design, to implement afunctionality of a respective component. Likewise, when the logic issoftware-based, then such logic can comprise one or more instructions,such as assembly code, machine code, object code, source code, or anyother type of instructions, which when executed, such as via running orcompilation, implement a functionality of a respective component.

The WAN 102 is communicably interposed between the first segment and thesecond segment. The WAN 102 can be operated via the first operator, thesecond operator, or a third operator. The WAN 102 can be established viaa telecommunication circuit. The WAN 102 can employ circuit switching orpacket switching methods. The WAN 102 can employ network protocolsincluding Transmission Control Protocol (TCP)/Internet Protocol (IP),which can be used deliver transport and addressing functions. However,other communication protocols can be used, whether additionally oralternatively, in whole or in part, such as File Transfer Protocol(FTP), Ethernet, Internet Message Access Protocol (IMAP) InternetControl Message Protocol (ICMP), Hypertext Transfer Protocol (HTTP), orothers. The WAN 102 can comprise circuit switched telephone lines, radiowave transmission, or optic fiber. In some embodiments, the firstsegment and the second segment communicably interface with each other,while avoiding the WAN 102, such via direct communication, such as viathe router 104.

Although the first segment is organized in a dual firewallconfiguration, the first segment can also be organized in a singlefirewall configuration, such as a three legged network model. The router104 is communicably interposed between the WAN 102 and the firewall 106.The firewall 106 is communicably interposed between the router 104 andthe network server 108. The network server 108 is communicablyinterposed between the firewall 106 and the firewall 110. For example, ademilitarized zone or a perimeter network can be formed, where thenetwork server 108 is positioned therein. The firewall 110 iscommunicably interposed between the application server 112 and thenetwork server 108. The firewall 110 is communicably interposed betweenthe LAN 116 and the network server 108. The application server 112 iscommunicably interposed between the firewall 110 and the database server114. The LAN 116 is communicably coupled to the firewall 110, theworkstation 118, the administrator terminal 120, and the multifunctiondevice 122. Note that communicative interpositioning or communicativecoupling can be direct or indirect, whether wired or wireless. Forexample, the network server 108, the application server 112, and theserver 112 can be contained in a single data center or distributed amonga plurality of data centers in any permutational/combinatory manner.

The router 104 forwards data packets from the WAN 102 to the firewalls106 and vice versa. Each of the firewalls 106, 110 is a network securitysystem, whether hardware and/or software, which monitors and controlsincoming and outgoing network traffic based on a set of security rules.Each of the firewalls 106, 110 can be a network firewall or a host-basedfirewall. Each of the firewalls 106, 110 can be identical or differentfrom each other in structure or operation.

The network server 108 serves content, such as a network page, a datastream, or a data feed. For example, the network server 108 can servecontent to the application server 112 in response receiving acorresponding request. For example, the network server 108 can push toor pull content from the application server 112. The network server 108can serve content, such as a network page, such as via pushing orpulling, to the workstation 118, the administrator terminal 120, and themultifunction device 122 over the LAN 116 in response receiving acorresponding request. Such service can be via a protocol, such as viaHTTP or a hypertext transfer protocol secure (HTTPS). For example, thenetwork page can be file-based and can be static or dynamic. Forexample, the network page can be dynamically generated and can be markuplanguage based, such as via a Hypertext Transfer Markup Language (HTML).For example, the network server 108 can comprises a web server, such asApache, Microsoft® Internet Information Server (IIS), Novell's NetWareserver, Google Web Server (GWS), or IBM Domino server.

The application server 112 hosts a software application and a set ofbusiness logic for the software application, such as a file comprising aspreadsheet or a worksheet. Therefore, as instructed by the softwareapplication, the application server 112 can communicably interface withthe network server 108 through the firewall 110 and the database server114. For example, the application server 112 can act as a middle-tierserver, with the network server 108 acting as front-tier server, and thedatabase server 114 acting as a back-end server. For example, theapplication server 112 can comprise an IBM WebSphere application serveror a SAP Web application server. In some embodiments, where the firewall110 is lacking, then the application server 112 can still communicablyinterface with the network server 108, which may be directly.

The application server 112 can comprise a plurality of independentcores, such as a multicore processor comprising a computing componentwith two or more independent processing units, which are the units thatread and execute program instructions, such as via multiprocessing ormultithreading. The instructions are processing instructions, such asadd, move data, or branch, but the cores can run multiple instructionsconcurrently, thereby increasing an overall operational speed for thesoftware application, which is amenable to parallel computing. The corescan process in parallel when concurrently accessing a file or any otherdata structure, as disclosed herein, while being compliant withatomicity, consistency, isolation, and durability (ACID) principles,which ensure that such data structure operations/transactions, such asread, write, erase, or others, are processed reliably, such as for datasecurity or data integrity. For example, a data structure can beaccessed, such as read or written, via at least two cores concurrently,where each of the cores concurrently processes a distinct data structurerecord or a distinct set of data such that at least two data structurerecords or at least two sets of the data are processed concurrently,without locking the data structure between such cores. However, notethat data locking is possible. Note that there can be at least twocores, such as two cores, three cores, four cores, six cores, eightcores, ten cores, twelve cores, or more. The cores may or may not sharecaches, and the cores may or may not implement message passing orshared-memory inter-core communication methods. Common networktopologies to interconnect cores include bus, ring, two-dimensionalmesh, and crossbar. Homogeneous multi-core systems include onlyidentical cores, heterogeneous multi-core systems can have cores thatare not identical. The cores in multi-core systems may implementarchitectures, such as very long instruction word (VLIW), superscalar,vector, or multithreading. In some embodiments, whether additionally oralternatively, in whole or in part, at least one of the network server108, the database server 114, the workstation 118, the terminal 120, orthe client 138 can comprise a plurality of independent cores, such as amulticore processor comprising a computing component with two or moreindependent processing units, which are the units that read and executeprogram instructions, such as via multiprocessing or multithreading, asdisclosed herein. Such configurations may enable parallel processing ofrelevant information, as disclosed herein, such as when used via manyusers for various tasks disclosed herein and thereby efficientlyincrease system computational speed.

The database server 114 hosts a database and a database managementsystem (DBMS), such as an Oracle database, a MS-SQL database, an MSAccess database, a Filemaker database, a DB2 database, or others. TheDBMS manages the database. The application hosted on the applicationserver 112 can communicably interface with the DBMS in order to requestvarious database operations, as disclosed herein, such as creatingrecords, modifying records, retrieving records, searching records,identifying records, deleting records, sorting records, or others, inwhole or in part. For example, some of various database input (I)/output(O) operations include reading, writing, editing, deleting, updating,searching, selecting, merging, sorting, erasing, formatting, or others.The DBMS can implement record locking on the database, such as for dataintegrity purposes. In some embodiments, the DBMS can avoid recordlocking.

The database stores data, whether in a raw state, a formatted state, anorganized stated, or any other accessible state, and allows access tosuch data, whether directly and/or indirectly. The database can be asingle database or a plurality of databases, whether hosted on a singlemachine or a plurality of machines, whether in a single data center ordistributed among a plurality of data centers. The database can compriseat least one of a relational database, a non-relational database, apost-relational database, an in-memory database, a hybrid database, anExtensible Markup Language (XML) database, a parallel database, adistributed database, a graph database, a mobile database, an operationdatabase, a probabilistic database, a real-time database, a spatialdatabase, a temporal database, an object oriented database, anunstructured data database, a terminology oriented database, or others.For example, the database can store a spreadsheet with a parentworksheet and a child worksheet, as disclosed herein.

The workstation 118 is programmed to run an application on an operatingsystem (OS), such as Windows, Linux, Android, MacOS, and/or others. Forexample, the application can comprise a browser, a productivityapplication, such as a word processor or a spreadsheet, a mobile app, orothers. The application is programmed to display a graphical userinterface (GUI), as disclosed herein. The GUI is programmed to displayan output and receive an input. For example, the output can comprise adisplay of a row of a parent worksheet populated, as disclosed herein,via an input device, such as a keyboard, a cursor device, a microphone,a camera, or a touchscreen, and a display of a tab of a child worksheetprogrammed for an activation via the input device, where the childworksheet is programmed for the input, such as to automatically and atleast partially inherit a cellular format or cellular content from theparent worksheet for subsequent editing/modification/appending, if any,where, after the input, the parent worksheet or the child worksheet, inwhole or in part, can be saved, submitted, or uploaded from theworkstation 118 to the application server 112 or the database server114, which may be through the network server 108 via the LAN 116 ordirectly to the application server 112 via the LAN 116. The input may befrom a user, such as a service provider employee or anothercomputer/software application. However, note that the GUI can receiveand display other information as well, as disclosed herein. Theworkstation 118 can be configured to interface with the multifunctiondevice 122, such as to print a report from the application via themultifunction device 122, such as in color or grayscale, such as via theLAN 116. The workstation 118 can communicate the input to theapplication server 112 via the LAN 116 and the firewall 110 or evenwithout the firewall 110. In response, the application server 112 canperform various data operations, as disclosed herein, such as to executethe software application and the set of business logic for the softwareapplication accordingly or request the DBMS to identify or modifyvarious records in the database hosted on the database server 114.

The administrator terminal 120 is programmed to allow maintenance ortroubleshooting of the first segment, such as the router 104, thefirewall 106, the network server 108, the firewall 110, the applicationserver 112, the database server 114, the LAN 116, the workstation 118,and the multifunction device 122. Such maintenance or troubleshootingcan involve spreadsheet or file settings, spreadsheet or fileversioning, data structure maintenance, software updates, debugging,access control, simulation, event logging, event monitoring, automation,or others. In some embodiments, the maintenance or the troubleshootingcan involve the second segment or the client computing device 124.

The multifunction device 122 can comprise a scanner, a fax, a printer, anetwork-based messaging interface, whether LAN or WAN based, such asemail, or any other functionality, in whole or in part, in anycombinatory manner. The multifunction device 122 can be used via theworkstation 118, the administrator terminal 120, the application server112, or other components of the first segment. The multifunction device122 can host an optical character recognition (OCR) engine to perform anOCR process, such as offline, on a scan, a fax, an email, or otherfunctionalities of the multifunction device 122. Alternatively oradditionally, the OCR process can be performed remote to themultifunction device 122, where the multifunction device 122 sends adocument or an image, whether as scanned, faxed, or emailed, to a remotecomputer and then receives the document or the image that has alreadybeen subject to the OCR process from the remote computer, whether theremote computer performs the OCR process or forward the document or theimage to another machine to perform the OCR process. For example, thespreadsheet can be populated, as disclosed herein, in a paper form andsubmitted for the OCR process via the multifunction device 122, asdisclosed herein. The client computing device 124 comprises a tabletcomputer. However, note that the client computing device 124 can be anytype of a computer, such as a desktop, a laptop, a mobile device, aphone, or any other suitable computer.

Note that any of the servers disclosed herein can be hardware-basedand/or software-based. Each of the servers is and/or is hosted on,whether directly and/or indirectly, a server computer, whetherstationary or mobile, such as a kiosk, a workstation, a vehicle, whetherland, marine, or aerial, a desktop, a laptop, a tablet, a mobile phone,a mainframe, a supercomputer, a server farm, and so forth. The servercomputer can comprise another computer system and/or a cloud computingnetwork. The server computer can run any type of an OS, such as MacOS,Windows, Android, Unix, Linux, and/or others. The server computer caninclude and/or be coupled to, whether directly and/or indirectly, aninput device, such as a mouse, a keyboard, a touchscreen, a biometricreader, a clicker, a microphone, or any other suitable input device. Theserver computer can include and/or be coupled to, whether directlyand/or indirectly, an output device, such as a display, a speaker, aprinter, or any other suitable output device. In some embodiments, theinput device and the output device can be embodied in one unit, such asa touch-enabled display, which can be haptic. Each of the servers canemploy load-balancing technologies and/or failover technologies foroperational efficiency, continuity, and/or redundancy. Each of theservers can be task-dedicated. At least two of the servers can be asingle server.

Note that the clients disclosed herein can be hardware-based and/orsoftware-based. Each of the clients is and/or is hosted on, whetherdirectly and/or indirectly, a client computer, whether stationary ormobile, such as a terminal, a kiosk, a workstation, a vehicle, whetherland, marine, or aerial, a desktop, a laptop, a tablet, a mobile phone,a mainframe, a supercomputer, a server farm, and so forth. The clientcomputer can comprise another computer system and/or cloud computingnetwork. The client computer can run any type of an OS, such as MacOS,Windows, Android, Unix, Linux, and/or others. The client computer caninclude and/or be coupled to an input device, such as a mouse, akeyboard, a camera, an accelerometer, a touchscreen, a biometric reader,a clicker, a microphone, or any other suitable input device. The clientcomputer can include and/or be coupled to an output device, such as adisplay, a speaker, a joystick, a printer, or any other suitable outputdevice. In some embodiments, the input device and the output device canbe embodied in one unit, such as a touch-enabled display, which can behaptic.

In one mode of operation, at least based on above, the server 112 canperform a method, which includes a set of steps. One step includes theserver 112 storing a first file comprising a spreadsheet with aworksheet, where the worksheet comprises at least a first row and asecond row.

The first row comprises a first statement cell comprising a firststatement, a first data type cell comprising a first data typeidentifier, a first logic cell comprising a first logic, and a firstfield cell comprising a first field identifier, whether immediatelyadjacent to or spaced apart from each other via a cell, whether empty orcontaining a content, in the first row. Note that the first row caninclude other cells, such as a first key cell comprising a first key,whether immediately adjacent to or spaced apart from each other via acell, whether empty or containing a content, in the first row.

The second row comprises a second statement cell comprising a secondstatement, a second data type cell comprising a second data typeidentifier, a second logic cell comprising a second logic, and a secondfield cell comprising a second field identifier, whether immediatelyadjacent to or spaced apart from each other via a cell, whether empty orcontaining a content, in the second row. Note that the second row caninclude other cells, such as a second key cell comprising a second key,whether immediately adjacent to or spaced apart from each other via acell, whether empty or containing a content, in the second row. Notethat at least one of the first row or the second row can comprise a keycell containing a key, such as a unique or primary identifier, where atleast one of the first statement or the second statement is identifiedvia the key, such as via calling the unique or primary identifier. Forexample, when the second row comprises the key cell, then the server 112can call the key based on the first logic in response to the evaluatingand then the second statement is identified via the key. Also, note thata cell in the first row and a cell in the second row can be shaped orsized identical to or different from each other. Note that the first rowand the second row can be immediately adjacent to each other or spacedapart from each other via a row in-between. Note that the file can be asingle file or a plurality of files. Also, note that other datastructures can be used, whether additionally or alternative to the file.Further, note that any number of rows in a worksheet of a spreadsheetcan be used. In some embodiments, the worksheet can comprise between 1and 10,000 rows, such as between 2 and 5,000 rows, such as less than4,000 rows. Note that this number is illustrative and more than 10,000rows can be used, for example, 1,000,000 rows.

Note that a cell operates as a shell for the content stored therein.Therefore, an operation involving the cell or the content stored thereinmay include generation/formation, storage, retrieval, population,copying, moving, editing, modifying, sorting, searching, sending,receiving, updating, deleting, encrypting, decrypting, de-duplicating,converting, uploading, downloading, or any other local or network-baseddata cell operation. The content can contain any alphanumeric, image,acoustic, binary, symbolic, equation, formula, logic, or any othercontent. For example, alphanumeric data can include an alphabeticstring, such as a statement or a question, whether or not including apunctuation mark of any type. For example, the alphanumeric data mayinclude a numerical string, including a mathematical symbol of any type.For example, symbol data can include a barcode or a quick response (QR)code. For example, the logic data can include a conditional/Booleanlogic statement (if/then logic evaluating whether a statement is true orfalse) of any branching depth, or any other type logic. For example, thefirst or second statement can include an alphabetic stringrepresentative of a question, such as “Are you currently licensed to flyan aircraft?” For example, the first or second data type identifier caninclude a Boolean type, a multi-value type, a string, a number, orothers. For example, the first or second logic can include analphanumeric string, such as “If QB00001 !=QB00101”. For example, thefirst or second logic can include a causal conditional string, such as“if q10==true, then ask q16” or “if Q359!=false, then ask q3, otherwiseask q 458”. The causal condition string may help data entry for userswith little or minimum programming knowledge. For example, the first orsecond field identifier can include an alphanumeric string, such as C6or 6x. For example, the first or second key can include an alphanumericstring, such as “B00010”.

One step includes the server 112 serving, such as dynamically rendering,a page, such as a webpage, to a client, such as the client computingdevice 124, such as via the server 108 over the WAN 102. Such servicecan be based on the client requesting the page from the server 108. Forexample, upon receiving the page request from the client computingdevice 124, such service can comprise the server generating and thensending a set of executable instructions, such as markup language code,such as HTML or XML, to the client for execution, such as locally, topresent the page, such as via a browser running on the OS of the client.Such service can comprise the server generating and then sending thepage to the client for presentation, such as locally, such as via abrowser running on the OS of the client or non-browser app running onthe OS, such as a mobile non-browser app. Such service can comprise anauthenticated session between the server 112 and the client, such as forsecurity purposes. The authenticated communication session can be viaHTTPS protocol. The authenticated communication session can be vialogin/password or biometrics.

The page visually presents, as dynamically generated, a first label anda first input element, such as a text entry box, a checkbox, a slider, abutton, a dropdown menu, a sliding scale, or another other visualelement. The first label comprises the first statement, such as analphabetic string, sourced from the first statement cell based ondynamic page generation, such as via the first key. The first inputelement is configured for a first input, such as via a radio or optionbutton or a dropdown menu, according to the first data type identifiersourced from the first data type cell based on dynamic page generation.The server 112 seeks, calls, or identifies the first statement in thefirst row, such as via the first key, such as when via a default key oras identified or pointed to via another key. Upon such seeking, calling,or identifying, the server 112 copies the first statement for dynamicpage generation, such as via the server 112 or the server 108 asinstructed via the server 112.

One step includes the server 112 receiving the first input from theclient, such as over the WAN 102 via the server 108, and in response tosuch receipt, evaluating the first input against the first logic, suchas if the first input matches a condition disclosed via the first logic,and serving, such as over the WAN 102 via the server 108, a second labeland a second input element onto the page based such evaluation. Thesecond label comprises the second statement sourced from the secondstatement cell based on dynamic page generation, such as via a secondkey. The second input element is configured for a second input accordingto the second data type identifier sourced from the second data typecell based on dynamic page generation. The server 112, upon evaluatingthe first input against the first logic, seeks, calls, or identifies thesecond statement in the second row, such as via the second key, such aswhen the first logic identifies or points to the second key. Upon suchseeking, calling, or identifying, the server 112 copies the secondstatement for dynamic page generation, such as via the server 112 or theserver 108 as instructed via the server 112. The page can be a singlepage, such that the page concurrently contains the first label, thesecond label, the first input element, and the second input element. Forexample, the single page can concurrently present the first label, thesecond label, the first input element, and the second input elementalong a horizontal scrolling plane, a vertical scrolling plane, or adiagonal scrolling plane. The page can be a plurality of pages, suchthat a first page contains the first label and the first input element,and a second page contains the second label and the second inputelement, with the first page and the second page being distinct pages,and the second page sequentially follows the first page. The first orsecond input can be of any data type, such an alphanumeric string, aBoolean value (true or false), a symbol, or others.

One step includes the server 112 receiving the second input, such asover the WAN 102, and in response insert the first input into a firstfield, such as an alphanumeric text entry field, of a second file, suchas a productivity document file, such as an MS Word or Excel file, or aPDF document or a markup language file, such as an HTML file, based onthe first field identifier, which identifies the first field in thesecond file, and the second input into a second field, such as a dataentry field, such as a checkbox, of the second file based on the secondfield identifier, which identifies the second field in the second file.The server 112 can store the second file before the inserting orretrieve the second file via the DBMS hosted on the server 114 from thedatabase hosted on the server 114. In addition, the server 112 cangenerate the second file before the inserting, whether immediatelybefore or not immediately before. In addition, the second file may be anoriginal file or a copy of another file, whether the copy is generatedvia the server 112 or the server 114. Additionally, the server 112 orthe server 114 can generate the second file in response, whetherimmediate or not, to receiving the second input. Moreover, the secondfile can comprise a unique identifier before the inserting. For example,the unique identifier can be a barcode, a QR code, an alphanumericstring, or an image. For example, the server 112 or the server 114 cangenerate, retrieve, copy, or otherwise access the second file based onthe unique identifier. In addition, if the page contains an alphanumericor image content, such as graphical content, then the server 112 or theserver 114 can be configured to filter out or avoid including suchcontent in the second file when generating the second file, such as fora streamlined appearance when the second file is presented, displayed,or printed. In some embodiments, the server 112 or the server 114 mayserve the second file to the client, such as the client computing device124, where the second file comprises an electronic signature field thatis ready to receive an electronic signature from the client. Forexample, such electronic signature may be useful for a network-basedintake of a mortgage or insurance application, the first statement, andthe second statements must match word-for-word what has been previouslysubmitted to a government agency, such as electronically. For example,where the first statement and the second statement are literally recitedin a third file in a first order, such as when previously submitted, thethird file is generated before the second file and before the page isserved with the first label and the first input element. The page maydisplay the first statement and the second statement in a second order,where the first order and the second order are different orders,although identical orders are possible as well. The second file can begenerated upon receiving a submit input, such as via an activation of abutton or hyperlink on the page, or without receiving a submit input,such as upon reaching a threshold data point in the worksheet, such as aspecific statement cell or logic cell. For example, the button candynamically change from inactive or invisible to active or visible basedon spreadsheet, such as upon reaching a threshold data point in theworksheet, such as a specific statement cell or logic cell. For example,the page can comprise a webpage with a dynamically updated form,including labels and fields. The page can contain a submission visualelement, such as a button, programmed to activate an upload of the firstinput or the second input from the client to the application server 112,such as for storage in a record of the server 114, where the record canbe subsequently accessed, such as via the DBMS as requested via theserver 112, for generating the second file.

In other embodiments, the page can be a single page or the pagecomprises a first page and a second page, where the first page comprisesthe first label and the first input element, wherein the second pagecomprises the second label and the second input element, wherein thefirst page and the second page are distinct pages, such as a sequence ofpages. The first row and the second row are not immediately adjacent toeach other, although immediately adjacent positioning is possible, aswell.

In some embodiments, the spreadsheet may comprise a cell comprising acontent for at least one of (a) a control of how at least one of thefirst input element or the second input element is presented on thepage, (b) a control of how at least one of the first label or the secondlabel is presented on the page, (c) a control of how a help tip ispresented for at least one of the first input element or the secondinput element is presented on the page, or (d) a control of a displayattribute of the page. Such cell may be included in the first row or thesecond row or a third row, whether on a same or different worksheet. Forexample, the control of how at least one of the first input element orthe second input element is presented on the page may control a lateralor longitudinal length, a color, a contrast, a position, a font, ashape, a size, or other relevant attribute. For example, the control ofhow at least one of the first label or the second label is presented onthe page may control a lateral or longitudinal length, a color, acontrast, a position, a font, a shape, a size, or other relevantattribute. For example, the control of how the help tip is presented forat least one of the first input element or the second input element ispresented on the page may control a lateral or longitudinal length, acolor, a contrast, a position, a font, a shape, a size, or otherrelevant attribute. The help tip may be sourced from the spreadsheet,such as in the first row or the second row. Further, note that the helptip may be sourced similarly to the first statement or the secondstatement. For example, the control of the display attribute of the pagemay control a lateral or longitudinal length, a color, a contrast, aposition, a font, a shape, a size, or other relevant attribute.

In some embodiments, the spreadsheet comprises a first worksheet and asecond worksheet, where the first worksheet comprises the first row andthe second worksheet comprises a second row. The first worksheet and thesecond worksheet can be a single worksheet or distinct worksheets. Forexample, where the page may be a first page, and the server 112 mayreceive a create worksheet request from the workstation 118 and inresponse create a third worksheet in the spreadsheet such that the thirdworksheet comprises a third row. The first page and the second page maybe distinct pages. The third row may inherit from at least one of thefirst row or the second row such that the third row comprises at leastone of a third statement cell comprising at least one of the firststatement or the second statement, a third data type cell comprising atleast one of the first data type identifier or the second data typeidentifier, a third logic cell comprising at least one of the firstlogic or the second logic, or a third field cell comprising at least oneof the first field identifier or the second field identifier. The singleworksheet, which may contain the first worksheet and the secondworksheet, and the third worksheet may be distinct worksheets.

Note that such inheritance, whether single, multiple, or multilevel, issimilar to inheritance in object-oriented programming, where a childobject inherits a property/attribute/feature from a parent object.Likewise, a child worksheet can be based on another worksheet (parentworksheet), whether in a same or different spreadsheet or file ordatabase or record or data structure, whether sourced locally or througha network, using a same implementation or specifying implementation tomaintain a same behavior (realizing an interface or inheritingbehavior). Such type of inheritance is a mechanism for code reuse and toallow independent extensions of an original worksheet or spreadsheet.For example, such relationships give rise to a worksheet hierarchy. Forexample, a child worksheet can inherit a row from a parent worksheet,such as responsive to a user input or automatically responsive to adetection of a trigger or a detection of a condition being met or adetection of a threshold being satisfied, and then such row can bemodified or appended to, such as via a population of another cell inthat row, such as responsive to a user input or automatically responsiveto a detection of a trigger or a detection of a condition being met or adetection of a threshold being satisfied. For example, a child worksheetcan inherit a first row from a parent worksheet and then a second rowcan be added, whether above or below the first line, where a content ofthe second row is responsive to or based on a content of the first rowor vice versa. For example, responsive to such inheritance, the server112 can serve a third label and a third input element onto a secondpage, which is distinct from the first page, where the third labelcomprises a statement sourced from the third statement cell, where thethird input element is configured for a third input according anidentifier sourced from the third data type cell. For example, theserver 112 may receive a modify request, such as an alphanumeric valueor other data type value, from a client, such as the workstation 118,and in response modify the third worksheet such that a content of atleast one of the third statement cell, the third data type cell, thethird logic cell, or the third field cell is changed based on the modifyrequest.

In some embodiments, the server 112, or along with the server 114, mayhost a network-based document management system, such as MS Sharepoint,Filesite, or Google Drive. The document management system may provide adocument check-in/check-out functionality in order to prevent a conflictwhere multiple users may want to concurrently modify the file comprisingthe spreadsheet. For example, responsive to the server 112 providing aGUI with a check-in/check-out functionality to a client, such as theworkstation 118, over the LAN 116, and a receiving a check-in requestfrom the client based on the GUI, the server 112 may add a new ormodified file to a document library or a list to replace a previousversion of the file, where the file comprises the spreadsheet. Likewise,responsive to the server 112 providing a GUI with a check-in/check-outfunctionality to a client, such as the workstation 118, over the LAN116, and a receiving a check-out request from the client based on theGUI, the server 112 may get a version of the file in a file list or afile library, where the file comprises the spreadsheet. Therefore, viachecking-out the file, a user of the client can prevent other users frommodifying/editing that a content of the file. Similarly, via checking-inthe file, the user of the client can allow others to edit the content ofthe file, without needing to worry about overriding changes that othershave made. When the file is checked out to the user of the client, thenthat user can work on that file, and other users cannot. Consequently,other users must wait for the user to check-in the file again (that is,perform a check-in) before the other users can modify/edit the file.While the file is checked-out, other users may or may not see only alast version of the file that was checked-in via the user of the clientand therefore the other users may or may not see a change that the userof the client, which is a current user of the file, has made on the filewhile the file has been checked-out. For example, where the client is afirst client, such as the client computing device 124, the server 112may receive a check-out request, such as a message, from a secondclient, such as the client operating the workstation 118, such as overthe LAN 116. The check-out request may be before the server 112 servesthe page with the first label and the first input element to the firstclient. In response to the check-out request, the server 112 maycheck-out the first file to the second client such that the server 112serves, such as over the LAN 116, a check-out message to a third client,such as the terminal 120, when the third client attempts to access thefirst file. Therefore, the server 112 prevents, such as via filelocking/privilege control/permission (read, write, delete) control, thethird client from accessing the first file when the third clientattempts to access the first file. The check-out message may inform thethird client that the first file is checked-out and may notify who thefirst file is check-out to, such as the second client. Subsequently, theserver 112 may receive a check-in request, such as a message, from thesecond client, such as over the LAN 116. The check-in request may bebefore the server 112 serves the page with the first label and the firstinput element. In response to the check-in request, the server 112checks-in the first file from the second client such that the thirdclient can access the first file. Such check-out and check-in processcan also occur when the server 112 is serving pages to clients, such asfor data integrity purposes.

In one mode of operation, whether additional to or alternative to anyembodiment disclosed herein, the server 112 may receive a request for apage from a client, such as the client computing device 124, such asover the WAN 102. In response to such receipt, the server 112 may accessa file comprising a spreadsheet, as disclosed herein, such as via theserver 114, generate a first set of instructions based on thespreadsheet, such as a set of HTML code, and serve the first set ofinstructions to the client such that the first set of instructionsexecutably presents (e.g., renders) the page on the client, such as overthe WAN 102. The spreadsheet comprises a first row and a second row,where the first row comprises a first statement cell comprising a firststatement, a first data type cell comprising a first data typeidentifier, and a first logic cell comprising a first logic, and wherethe second row comprises a second statement cell comprising a secondstatement, a second data type cell comprising a second data typeidentifier, and a second logic cell comprising a second logic, asdisclosed herein. The page comprises a first label and a first inputelement, where the first label comprises the first statement, and wherethe first input element is configured for a first input based on thefirst data type identifier, as disclosed herein. Consequently, theserver receives the first input, as disclosed herein. In response tosuch receipt, the server 112 evaluates the first input against the firstlogic, identifies the second statement based on the evaluation,generates a second set of instructions based on the identifying, andserves the second set of instructions to the client such that the secondset of instructions executably presents a second label and a secondinput element on the page, as disclosed herein. For example, the firstset of instructions and the second set of instructions can be a singleset of instructions or multiple sets of instructions, whether identicalto or different from each other in type, such as HTML, XML, or others.For example, the server 112 can serve the client with a single set ofinstructions, including the first set of instructions and the second setof instructions, yet the second set of instructions is notclient-processed until the first set of instructions is client-processedor the second set of instructions is client-processed but delayed forclient presentation, such as for proper sequence of reflexivequestioning. The second label comprises the second statement, asdisclosed herein. The second input element is configured for a secondinput based on the second data type identifier, as disclosed herein.

In one mode of operation, whether additional to or alternative to anyembodiment disclosed herein, the server 112 may access a file comprisinga spreadsheet, where the spreadsheet comprises a parent worksheet, asdisclosed herein. The parent worksheet comprises a first row, where thefirst row comprises a first statement cell comprising a first statement,a first data type cell comprising a first data type identifier, and afirst logic cell comprising a first logic, as disclosed herein. Theserver 112 may receive a first command from a client, such as theworkstation 118, such as over the LAN 116, and in response, the server112 may create a child worksheet in the spreadsheet, where the childworksheet comprises a second row. The second row inherits the first rowsuch that the second row comprises, whether in a same or different data,organizational, or presentation format, a second statement cellcomprising the first statement, a second data type cell comprising thefirst data type identifier, and a second logic cell comprising the firstlogic, as disclosed herein. The server 112 may receive a second commandfrom the client, and in response, the server 112 may modify at least oneof the first statement in the second statement cell, the first data typeidentifier in the second data type cell, or the first logic in thesecond logic cell, as disclosed herein. For example, the second commandmay call a function of the spreadsheet, such as a sum function, orcomprise a data input, such as an alphanumeric string or a data typevalue, as disclosed herein. Note that the second command may enable anaddition, deletion, modification, editing, appending or any other dataamendment to the child worksheet, on cellular, columnar, or row level,as disclosed herein. The server 112 may generate a set of instructionscorresponding to a page based on the child worksheet such that the pagecomprises a label and an input element, where the label comprises thefirst statement from the second statement cell as modified if at all,and where the input element is configured for an input based on thefirst data type identifier in the second data type cell as modified ifat all, as disclosed herein. The server 112 may serve the set ofinstructions to the second client, and in response to such service, theserver 112 may receive the input, evaluate the input against the firstlogic in the second logic cell as modified if at all, and perform anaction based on the evaluating, as disclosed herein. For example, theaction can comprise data structure/message generation/formation,storage, retrieval, population, copying, moving, editing, modifying,sorting, searching, sending, receiving, updating, deleting, encrypting,decrypting, de-duplicating, converting, uploading, downloading, or anyother local or network-based data structure/message operation associatedwith a structure/message (data shell) or the data itself (content), asdisclosed herein. The data (content) can contain any alphanumeric,image, acoustic, binary, symbolic, equation, formula, or any othercontent, as disclosed herein. For example, a spreadsheet can comprisethe data (content). For example, the action can comprise a generation ofa file, a service of a statement, a memorialization of an input, or aservice of a message or any other actions disclosed herein.

In one mode of operation, whether additional to or alternative to anyembodiment disclosed herein, the server 112 may serve a user interfaceto a first client, such as the workstation 118, such as over the LAN116, as disclosed herein. The user interface comprises a check-outelement configured for a check-out input related to the file, such as afile name identifier for user selection or a checkbox, and a check-inelement configured for a check-in input related to the file, such as afile name identifier for user selection or a checkbox, as disclosedherein. For example, the file can be checked-out by opening the file andthe file can be checked-in by closing the file, as disclosed herein. Thefile comprises a spreadsheet, where the spreadsheet comprises a row, asdisclosed herein. The row comprises a statement cell comprising astatement, a data type cell comprising a data type identifier, and alogic cell comprising a logic, as disclosed herein. The server 112receives the check-out input from the first client, such as over the LAN116, and in response, the server 112 checks-out the file such that thefile cannot be modified by a second client, such as the terminal 120,until the server 112 receives the check-in input from the first client,and modifies at least one of the statement, the data type identifier, orthe logic based on a write request from the first client during themodifying, as disclosed herein. For example, the write request mayenable an addition, deletion, modification, editing, appending or anyother data amendment to the spreadsheet, on cellular, columnar, or rowlevel, as disclosed herein. The server 112 may receive the check-ininput from the first client after the modifying, and in response to suchreceipt, the server 112 may check-in the file such that the file can bemodified by the second client, as disclosed herein. The server 112 maygenerate a set of instructions corresponding to a page based on thespreadsheet such that the page comprises a label and an input element,as disclosed herein. The label comprises the statement as modified if atall, as disclosed herein. The input element is configured for an inputbased on the data type identifier as modified if at all, as disclosedherein. The server 112 may receive the input in response to serving theset of instructions to a third client, such as the client computingdevice 124 and evaluate the input against the logic as modified if atall, and perform n action based on the evaluating, as disclosed herein.For example, the action can comprise data structure/messagegeneration/formation, storage, retrieval, population, copying, moving,editing, modifying, sorting, searching, sending, receiving, updating,deleting, encrypting, decrypting, de-duplicating, converting, uploading,downloading, or any other local or network-based data structure/messageoperation associated with a structure/message (data shell) or the dataitself (content), as disclosed herein. The data (content) can containany alphanumeric, image, acoustic, binary, symbolic, equation, formula,or any other content, as disclosed herein. For example, a spreadsheetcan comprise the data (content). For example, the action can comprise ageneration of a file, a service of a statement, a memorialization of aninput, or a service of a message or any other actions disclosed herein.Note that the check-in/check-out technology can be implemented via thedocument management system, as disclosed herein, such as MS SharePointor Google Drive.

In some embodiments, the file with the spreadsheet can be stored localon a client, such as on the client computing device 124 or a memorydevice coupled to the client, such as an external hard disk, or anoptical drive, a network-based storage drive, or a flash drive. Forexample, the file with the spreadsheet can be stored remote from theclient, such as a network-based file hosting service, which may providea cloud-based storage, file synchronization, personal cloud, or clientsoftware. For example, the network-based file hosting service may allowa user to create a folder on the user's computer, where the folder issynchronized, whether in real-time or periodically, with thenetwork-based file hosting service such that the folder appears to besame folder (with same contents) regardless of which computing device isused to view the folder. For example, the network-based file storageservice can comprise Dropbox or Google Drive. Therefore, the file withthe spreadsheet can be locally processed, whether additional to oralternative to server processing.

In some embodiments, any strings/symbols/identifiers disclosed hereincan be in any human or machine language in any alphanumeric font or viaany pictorial, symbolic, or sound representation, such as a string, anicon, a banner, an audio, a video, or a photo. Also, note that if anystrings/symbols/identifiers disclosed herein are improperly formatted,then the application server 112 may format into an appropriate format.For example, if the application server 112 receives astring/symbol/identifier in a first format, then the application server112 can convert the string/symbol/identifier from the first format intoa second format, such as for data structure or processor compatibilityor computational efficiency. For the example, the first format can be ina first character-encoding scheme and the second format can be in asecond character-encoding scheme. For example, the first format can anarchive or zipped file and the second format can be un-archived orunzipped file.

In some embodiments, an input can be in a natural language form, such asin a sentence, sound, or image, where such input can be subsequentlyprocessed via the application server 112 implementing a natural languageprocessing algorithms, such as based on statistical model machinelearning. For example, such algorithms can involve automaticsummarization, co-reference resolution, discourse analysis, machinetranslation, morphological segmentation, named entity recognition (NER),native language identification, natural language generation, naturallanguage understanding, OCR, part-of-speech tagging, parsing, questionanswering, relationship extraction, sentence breaking, sentimentanalysis, speech recognition, speech segmentation, stemming, topicsegmentation and recognition, word segmentation, word sensedisambiguation, or others.

FIG. 2 shows a flowchart of an embodiment of a process for filegeneration according to the present disclosure. A process 200 includes aplurality of blocks 202-230. The process 200 can be performed via thetopology 100 of FIG. 1 , in whole or in part.

In a block 202, the server 112 checks-out a first file containing aspreadsheet with a first row and a second row, as disclosed herein. Thefirst file is checked-out to a first client, such as the workstation118. Therefore, a second client, such as the terminal 120, is unable tocheck-in the first file at least for modifying/editing, such as for dataintegrity purposes. For example, the checking-out can be managed via thedocument management system, as disclosed herein. The server 112 may notalways check out the first file; it may retrieve the file from adatabase.

In a block 204, the server 112 receives a plurality of first row cellinputs from the first client, as disclosed herein. For example, thefirst row cell inputs comprise the first statement, the first data typeidentifier, the first logic, and the first field identifier. Note thatother row inputs are possible, such as a key cell input, as disclosedherein.

In a block 206, the server 112 populates the first row with the firstrow cell inputs such that the first row comprises a first statement cellcomprising the first statement, a first data type cell comprising thefirst data type identifier, a first logic cell comprising the firstlogic, and a first field cell comprising the first field identifier, asa single cell or a multiple cells, in whole or in part, whetherimmediately adjacent to or spaced apart from each other via a cell,whether empty or containing a content, in the first row. The first rowcan include other cells, such as a first key cell comprising a firstkey, whether immediately adjacent to or spaced apart from each other viaa cell, whether empty or containing a content, in the first row.

In a block 208, the server 112 receives a plurality of second row cellinputs from the first client, as disclosed herein. For example, thesecond row cell inputs comprise the second statement, the second datatype identifier, the second logic, and the second field identifier. Notethat other row inputs are possible, such as a key cell input, asdisclosed herein.

In a block 210, the server 112 populates the second row with the secondrow cell inputs such that the second row comprises a second statementcell comprising the second statement, a second data type cell comprisingthe second data type identifier, a second logic cell comprising thesecond logic, and a second field cell comprising the second fieldidentifier, as a single cell or a multiple cells, in whole or in part,whether immediately adjacent to or spaced apart from each other via acell, whether empty or containing a content, in the second row. Notethat the second row can include other cells, such as a second key cellcomprising a second key, whether immediately adjacent to or spaced apartfrom each other via a cell, whether empty or containing a content, inthe second row. Note that at least one of the first row or the secondrow can comprise a key cell containing a key, such as a unique orprimary identifier, where at least one of the first statement or thesecond statement is identified via the key, such as via calling theunique or primary identifier. For example, when the second row comprisesthe key cell, then the server 112 can call the key based on the firstlogic in response to the evaluating and then the second statement isidentified via the key. A cell in the first row and a cell in the secondrow can be shaped or sized identical to or different from each other.The first row and the second row can be immediately adjacent to eachother or spaced apart from each other via a row in-between. The file canbe a single file or a plurality of files. Also, other data structurescan be used, whether additionally or alternative to the file. Further,note that any number of rows in a worksheet of a spreadsheet can beused. In some embodiments, the worksheet can comprise between 1 and10,000 rows, such as between 2 and 5,000 rows, such as less than 4,000rows. Note that this number is illustrative and more than 10,000 rowscan also be used.

A cell can operate as a shell for a content stored therein. Therefore,an operation involving the cell or the content stored therein mayinclude generation/formation, storage, retrieval, population, copying,moving, editing, modifying, sorting, searching, sending, receiving,updating, deleting, encrypting, decrypting, de-duplicating, converting,uploading, downloading, or any other local or network-based data celloperation. The content can contain any alphanumeric, image, acoustic,binary, symbolic, equation, formula, logic, or any other content. Forexample, alphanumeric data can include an alphabetic string, such as astatement or a question, whether or not including a punctuation mark ofany type. For example, the alphanumeric data include a numerical string,including a mathematical symbol of any type. For example, symbol datacan include a barcode or a quick response (QR) code. For example, thelogic data can include a conditional/Boolean logic statement (if/thenlogic evaluating whether a statement is true or false) of any branchingdepth, or any other type logic. For example, the first or secondstatement can include an alphabetic string representative of a question,such as “Are you currently licensed to fly an aircraft?” For example,the first or second data type identifier can include a Boolean type, amulti-value type, a string, a number, or others. For example, the firstor second logic can include an alphanumeric string, such as “If QB00001!=QB00101”. For example, the first or second logic can include a causalconditional string, such as “if q10==true, then ask q16” or “ifQ359!=false, then ask q3, otherwise ask q 458”. Note that the causalcondition string may help data entry for users with little or minimumprogramming knowledge. For example, the first or second field identifiercan include an alphanumeric string, such as C6 or 6x. For example, thefirst or second key can include an alphanumeric string, such as“B00010”. Furthermore, a cell may “call out” another operation that maybe performed by another computing device coupled with the clientcomputing device 124.

In a block 212, the server 112 checks-in the first file containing, asdisclosed herein. The first file is checked-in from the first client.Therefore, the second client is able to check-out the first file atleast for modifying/editing. For example, the checking-in can be managedvia the document management system, as disclosed herein.

In a block 214, the server 112 serves a page with a first label and afirst input field based on the first row. For example, the server 112may serve, such as dynamically, a page, such as a webpage, to a client,such as the client computing device 124, such as via the server 108 overthe WAN 102. Such service can be based on the client requesting the pagefrom the server 108. For example, upon receiving the page request fromthe client, such service can comprise the server 112 generating and thensending a set of executable instructions, such as markup language code,such as HTML or XML, to the client for execution, such as locally, topresent the page, such as via a browser running on the OS of the client.Note that such service can comprise the server 112 generating and thensending the page to the client for presentation, such as locally, suchas via a browser running on the OS of the client or non-browser apprunning on the OS, such as a mobile non-browser app. Note that suchservice can comprise an authenticated session between the server 112 andthe client, such as for security purposes. The authenticatedcommunication session can be via HTTPS protocol. The authenticatedcommunication session can be via login/password or biometrics.

For example, the page visually presents, as dynamically generated, thefirst label and the first input element, such as a text entry box, acheckbox, a slider, a button, a dropdown menu, a sliding scale, oranother other visual element. The first label comprises the firststatement, such as an alphabetic string, sourced from the firststatement cell based on dynamic page generation, such as via the firstkey. The first input element is configured for a first input, such asvia a radio or option button or a dropdown menu, according to the firstdata type identifier sourced from the first data type cell based ondynamic page generation. Note that the server 112 seeks, calls, oridentifies the first statement in the first row, such as via the firstkey, such as when via a default key or as identified or pointed to viaanother key. Upon such seeking, calling, or identifying, the server 112copies the first statement for dynamic page generation, such as via theserver 112 or the server 108 as instructed via the server 112.

In a block 216, the server 112 receives a first field input from thefirst input field, such as the first input element. For example, theserver 112 receives the first field input from the client, such as overthe WAN 102 via the server 108.

In a block 218, the server 112 evaluates the first field input againstthe first row. For example, the server 112 evaluates the first fieldinput against the first logic, such as if the first input matches acondition disclosed via the first logic.

In a block 220, the server 112 serves a second label and a second inputfield onto the page based on the second row. For example, the server 112can serve, such as over the WAN 102 via the server 108, the second labeland the second input element onto the page based such evaluation. Thesecond label comprises the second statement sourced from the secondstatement cell based on dynamic page generation, such as via a secondkey. The second input element is configured for a second input accordingto the second data type identifier sourced from the second data typecell based on dynamic page generation. Note that the server 112, uponevaluating the first input against the first logic, seeks, calls, oridentifies the second statement in the second row, such as via thesecond key, such as when the first logic identifies or points to thesecond key. Upon such seeking, calling, or identifying, the server 112copies the second statement for dynamic page generation, such as via theserver 112 or the server 108 as instructed via the server 112. Note thatthe page can be a single page, such that the page concurrently containsthe first label, the second label, the first input element, and thesecond input element. For example, the single page can concurrentlypresent the first label, the second label, the first input element, andthe second input element along a horizontal scrolling plane, a verticalscrolling plane, or a diagonal scrolling plane. Note that the page canbe a plurality of pages, such that a first page contains the first labeland the first input element, and a second page contains the second labeland the second input element, with the first page and the second pagebeing distinct pages, and the second page sequentially follows the firstpage. Note that the first or second input can be of any data type, suchan alphanumeric string, a Boolean value (true or false), a symbol, orothers.

In a block 222, the server 112 receives a second field input from thesecond input field. For example, the server 112 can receive the secondinput, such as over the WAN 102.

In a block 224, the server 112 generates a second file containing afirst file field and a second file field. Alternatively, the second fileis preexisting and can be copied and then populated or populated withoutcopying. The generation of the second file can be responsive toreceiving the second field input.

In a block 226, the server 112 inserts the first input into the firstfile field, such as an alphanumeric text entry field, of the secondfile, such as a productivity document file, such as an MS Word or Excelfile, or a PDF document or a markup language file, such as an HTML file,based on the first field identifier, which identifies the first filefield in the second file.

In a block 228, the server 112 inserts the second input into the secondfile field, such as a data entry field, such as a checkbox, of thesecond file based on the second field identifier, which identifies thesecond file field in the second file.

In a block 230, the server 112 saves the second file, as populated. Suchsaving can be local or network-based, as disclosed herein. Note that theserver 112 can store the second file before the inserting or retrievethe second file via the DBMS hosted on the server 114 from the databasehosted on the server 114. Also, note that the server 112 can generatethe second file before the inserting, whether immediately before or notimmediately before. Also, note that the second file may be an originalfile or a copy of another file, whether the copy is generated via theserver 112 or the server 114. Additionally, note that the server 112 orthe server 114 can generate the second file in response, whetherimmediate or not, to receiving the second input. Moreover, the secondfile can comprise a unique identifier before the inserting. For example,the unique identifier can be a barcode, a QR code, an alphanumericstring, or an image. For example, the server 112 or the server 114 cangenerate, retrieve, copy, or otherwise access the second file based onthe unique identifier. In addition, if the page contains an alphanumericor image content, such as graphical content, then the server 112 or theserver 114 can be configured to filter out or avoid including suchcontent in the second file when generating the second file, such as fora streamlined appearance when the second file is presented, displayed,or printed. In some embodiments, the server 112 or the server 114 mayserve the second file to the client, such as the client computing device124, where the second file comprises an electronic signature field thatis ready to receive an electronic signature from the client. Forexample, such electronic signature may be useful for a network-basedintake of a mortgage or insurance application and the first statementand the second statements must match word-for-word what has beenpreviously submitted to a government agency, such as electronically. Forexample, where the first statement and the second statement areliterally recited in a third file in a first order, such as whenpreviously submitted, the third file is generated before the second fileand before the page is served with the first label and the first inputelement. The page may display the first statement and the secondstatement in a second order, where the first order and the second orderare different orders, although identical orders are possible as well.Note that the second file can be generated upon receiving a submitinput, such as via an activation of a button or hyperlink on the page,or without receiving a submit input, such as upon reaching a thresholddata point in the worksheet, such as a specific statement cell or logiccell. For example, the button can dynamically change from inactive orinvisible to active or visible based on spreadsheet, such as uponreaching a threshold data point in the worksheet, such as a specificstatement cell or logic cell. For example, the page can comprise awebpage with a dynamically updated form, including labels and fields.The page can contain a submission visual element, such as a button,programmed to activate an upload of the first input or the second inputfrom the client to the application server 112, such as for storage in arecord of the server 114, where the record can be subsequently accessed,such as via the DBMS as requested via the server 112, for generating thesecond file.

FIG. 3 shows a flowchart of an embodiment of a process for cellprocessing according to the present disclosure. A process 300 includes aplurality of blocks 302-324. The process 300 can be performed via thetopology 100 of FIG. 1 , in whole or in part.

In a block 302, the server 112 accesses a first key cell in a first rowof a spreadsheet containing the first row and a second row, as disclosedherein. The first row comprises a first statement cell comprising afirst statement, a first data type cell comprising a first data typeidentifier, a first logic cell comprising a first logic, a first fieldcell comprising the first field identifier, and the first key cellcomprising a first key. For example, the server 112 can access the firstkey in the first key cell. Note that such cell order is one example andother cell orders are possible, in any permutational or combinatorymanner, such as the first key cell being positioned in a first column ofa worksheet of the spreadsheet. Further, note that at least two of suchfirst row cells can be a single cell. Likewise, the second row comprisesa second statement cell comprising a second statement, a second datatype cell comprising a second data type identifier, a second logic cellcomprising a second logic, a second field cell comprising a second fieldidentifier, and a second key cell comprising a second key. Further, notethat at least two of such second row cells can be a single cell. Notethat such cell order is one example and other cell orders are possible,in any permutational or combinatory manner, such as the second key cellbeing positioned in the first column or the second column of theworksheet of the spreadsheet. Also, note that a cell in the first rowand a cell in the second row can be shaped or sized identical to ordifferent from each other. Note that the first row and the second rowcan be immediately adjacent to each other or spaced apart from eachother via a row in-between.

Note that a cell operates as a shell for the content stored therein.Therefore, an operation involving the cell or the content stored thereinmay include generation/formation, storage, retrieval, population,copying, moving, editing, modifying, sorting, searching, sending,receiving, updating, deleting, encrypting, decrypting, de-duplicating,converting, uploading, downloading, or any other local or network-baseddata cell operation. The content can contain any alphanumeric, image,acoustic, binary, symbolic, equation, formula, logic, or any othercontent. For example, alphanumeric data can include an alphabeticstring, such as a statement or a question, whether or not including apunctuation mark of any type. For example, the alphanumeric data includea numerical string, including a mathematical symbol of any type. Forexample, symbol data can include a barcode or a quick response (QR)code. For example, the logic data can include a conditional/Booleanlogic statement (if/then logic evaluating whether a statement is true orfalse) of any branching depth, or any other type logic. For example, thefirst or second statement can include an alphabetic stringrepresentative of a question, such as “Are you currently planning toskydive?”. For example, the first or second data type identifier caninclude a Boolean type, a multi-value type, a string, a number, orothers. For example, the first or second logic can include analphanumeric string, such as “If QB00031<QB00205A”. For example, thefirst or second logic can include a causal conditional string, such as“if q10==true, then ask q16” or “if Q359!=4, then go q3, otherwise go toq458”. Note that other logic operations are possible, whetheradditionally or alternatively, such as greater than or lesser than,whether inclusively or exclusively, addition, subtraction,multiplication, division, variable assignment, functions, string contentoperations, network access (data pull/push or dataread/write/delete/append), or other logic. For example, some of suchlogic may be found in or be similar to a computer language, such asPerl, Python, or JavaScript. Moreover, note that if the spreadsheet hasa macro functionality, then the macro functionality can be used, whetheradditionally or alternatively. Further, note that the causal conditionstring may help data entry for users with little or minimum programmingknowledge. For example, the first or second field identifier can includean alphanumeric string, such as C6 or 6x. For example, the first orsecond key can include an alphanumeric string, such as “B00010”.Further, note that any number of rows in a worksheet of a spreadsheetcan be used. In some embodiments, the worksheet can comprise between 1and 10,000 rows, such as between 2 and 5,000 rows, such as less than4,000 rows. Note that this number is illustrative and more than 10,000rows can be used, for example, a 1,000,000 rows.

In a block 304, the server 112 copies the first statement in the firstrow from the first statement cell. For example, the first statement canbe copied based on the server 112 calling the first key in the first keycell and then being directed to the first statement cell to retrieve thefirst statement therefrom.

In a block 306, the server 112 serves a page with a first label and afirst input field based on the first identifier. For example, the server112 may serve, such as dynamically, the page, such as a webpage, to aclient, such as the client computing device 124, such as via the server108 over the WAN 102. Such service can be based on the client requestingthe page from the server 108. For example, upon receiving the pagerequest from the client, such service can comprise the server 112generating and then sending a set of executable instructions, such asmarkup language code, such as HTML or XML, to the client for execution,such as locally, to present the page, such as via a browser running onthe OS of the client. Note that remote execution is possible, whetheradditionally or alternatively, such as when the client is running aAmazon Silk browser. Further, note that such service can comprise theserver 112 generating and then sending the page to the client forpresentation, such as locally, such as via a browser running on the OSof the client or non-browser app running on the OS, such as a mobilenon-browser app. Also, note that such service can comprise anauthenticated session between the server 112 and the client, such as forsecurity purposes. The authenticated communication session can be viaHTTPS protocol. The authenticated communication session can be vialogin/password or biometrics. For example, the page visually presents,as dynamically generated, the first label and the first input element,such as a text entry box, a checkbox, a slider, a button, a dropdownmenu, a sliding scale, or another other visual element. The first labelcomprises the first statement, such as an alphabetic string, sourcedfrom the first statement cell based on dynamic page generation, such asvia the first key. The first input element is configured for a firstinput, such as via a radio or option button or a dropdown menu,according to the first data type identifier sourced from the first datatype cell based on dynamic page generation. As noted above, the server112 may seek, call, or identify the first statement in the first row,such as via the first key, such as when via a default key or asidentified or pointed to via another key. Upon such seeking, calling, oridentifying, the server 112 copies the first statement for dynamic pagegeneration, such as via the server 112 or the server 108 as instructedvia the server 112.

In a block 308, the server 112 receives a first input from the firstinput element. For example, the server 112 receives the first input fromthe client, such as the client computing device 124, such as over theWAN 102 via the server 108. For example, the first input can comprise aBoolean value, such as true or false, or an alphanumeric string, such as“yes” or “sometimes” or “1980” or “5/27/1974” or “May 3, 2001.” Notethat the server 112 can store the first input locally or in the databasehosted on the server 114. Such storage can persist temporarily orpermanently. For example, the server 112 can communicably interface withthe server 114 for storing or using the first input.

In a block 310, the server 112 evaluates the first input against thefirst logic cell in the first row. For example, the server 112 evaluatesthe first input against the first logic comprised in the first logiccell, such as whether the first input matches/satisfies or does notmatch/satisfy a condition/threshold disclosed via the first logic. Forexample, when (1) the first statement is a statement 42, such as whetheridentified as such via the first key in the first row or contained in arow 42 of a worksheet, and (2) the first input is associated with thefirst statement, such as responsive to the first statement beingpresented in the first label on the page, and (3) the first inputcomprises a true value, and (4) the first logic comprises a causalconditional string “if Q42==T, then seek Q50, otherwise seek Q19,” thenthe server 112 would evaluate the true value in the first input againstthe causal condition string as being present/existent/matched/satisfiedand then seek a statement 50, such as whether identified as such via thesecond key in the second row or contained in a row 50 of the worksheet.In contrast, if the first input comprises a false value, then the server112 would seek a statement 19, such as whether identified as such via athird key in a third row or contained in a row 19 of the worksheet. Notethat the worksheet can be a single worksheet or a plurality ofworksheets.

In a block 312, the server 112 identifies a second key cell in a secondrow of the spreadsheet. For example, the server 112 can access thesecond key in the second key cell. For example, the server 112 canaccess, such as via calling, the second key in the second key cell basedon the first logic in the first logic cell in response to the evaluatingin the block 310 and then the second statement is identified via thesecond key. For example, when the first logic states “go to Q30” or“seek s12,” then the server 112 can be programmed to go/seek a row 30 orrow 12, such as whether identified as such via the second key in thesecond row or contained in a row 30 or row 12 of the worksheet.

In a block 314, the server 112 copies the second statement in the secondrow from the second statement cell. For example, the second statementcan be copied based on the server 112 calling the second key in thesecond key cell and then being directed to the second statement cell toretrieve the second statement therefrom.

In a block 316, the server 112 serves a second label and a second inputelement based on a second data type identifier in the second row ontothe page. For example, the server 112 can serve, such as dynamically,such as over the WAN 102 via the server 108, the second label and thesecond input element onto the page based such evaluation. For example,such service can be based on the client requesting the page from theserver 108. The second label comprises the second statement sourced fromthe second statement cell based on dynamic page generation, such as viathe second key. The second input element is configured for a secondinput according to the second data type identifier sourced from thesecond data type cell based on dynamic page generation. For example, thepage visually presents the second label and the second input element,such as a text entry box, a checkbox, a slider, a button, a dropdownmenu, a sliding scale, or another other visual element. The second labelcomprises the second statement, such as an alphabetic string, sourcedfrom the second statement cell based on dynamic page generation, such asvia the second key. The second input element is configured for a secondinput, such as via a radio or option button or a dropdown menu,according to the second data type identifier sourced from the seconddata type cell based on dynamic page generation.

Note that the page can be a single page, such that the page concurrentlycontains the first label, the second label, the first input element, andthe second input element. For example, the single page can concurrentlypresent the first label, the second label, the first input element, andthe second input element along a horizontal scrolling plane, a verticalscrolling plane, or a diagonal scrolling plane. Note that the page canbe a plurality of pages, such that a first page contains the first labeland the first input element, and a second page contains the second labeland the second input element, with the first page and the second pagebeing distinct pages, and the second page sequentially follows the firstpage.

Note that the first or second input can be of any data type, whetheridentical to or different from each other, such an alphanumeric string,a Boolean value (true or false), a symbol, or others. Further, note thatthe server 112 may serve second label and the second input element ontothe page based such evaluation during a same session when the firstlabel and the first input element were served, such as a successivesequence of page events during a session. Note that the session can be asingle session or a plurality of sessions, such as a resume from a leftoff point session. For example, upon receiving the page request from theclient, such service can comprise the server 112 generating and thensending a set of executable instructions, such as markup language code,such as HTML or XML, to the client for execution, such as locally, topresent the second label and the second input element onto the page,such as via a browser running on the OS of the client. Note that remoteexecution is possible, whether additionally or alternatively, such aswhen the client is running an Amazon Silk browser. Further, note thatsuch service can comprise the server 112 generating and then sending thepage to the client for presentation, such as locally, such as via abrowser running on the OS of the client or non-browser app running onthe OS, such as a mobile non-browser app. Also, note that such servicecan comprise an authenticated session between the server 112 and theclient, such as for security purposes. The authenticated communicationsession can be via HTTPS protocol. The authenticated communicationsession can be via login/password or biometrics.

In a block 318, the server 112 receives a second input from the secondinput element. For example, the server 112 receives the second inputfrom the client, such as the client computing device 124, such as overthe WAN 102 via the server 108. For example, the second input cancomprise a Boolean value, such as true or false, or an alphanumericstring, such as “no” or “never” or “1991” or “27/2/1982” or “4 June2001.” Note that the server 112 can store the second input locally or inthe database hosted on the server 114. Such storage can persisttemporarily or permanently. For example, the server 112 can communicablyinterface with the server 114 for storing or using the second input.Note that although FIG. 3 shows processing for the first row and thesecond row, any number of rows can be used, as disclosed herein. Forexample, the second row can call a third row, which may call a fourthrow, whether in a same or different worksheet in a same or differentspreadsheet. Note that any rows disclosed herein can be immediatelyconsecutive/adjacent or can be spaced apart in any manner.

In a block 320, the server 112 generates, such as via creating, a secondfile containing a first field, such as an alphanumeric string or Booleandata entry field, and a second field, such as an alphanumeric string orBoolean data entry field. Alternatively, the second file is preexistingand can be copied and then populated, as disclosed herein, or populatedwithout copying, such as the second file being original, includingunique, such as via a unique identifier contained therein. Thegeneration of the second file can be responsive to receiving the secondfield input. The second file can comprise a productivity document file,such as an MS Word or Excel file, or a PDF document or a markup languagefile, such as an HTML file, an electronic document file, a databaserecord, or any other file. For example, the first field can beconfigured for an alphanumeric string input, such as a text field, andthe second field input can be configured for a Boolean data input, suchas a checkbox.

In a block 322, the server 112 populates the first field with the firstinput based on a first field identifier in the first row. For example,the server 112 inserts, such as via copying and writing, the first inputinto the first file field based on the first field identifier, whichidentifies the first file field in the second file.

In a block 324, the server 112 populates the second field with thesecond input based on a second field identifier in the second row. Forexample, the server 112 inserts, such as via copying and writing, thesecond input into the second file field based on the second fieldidentifier, which identifies the second file field in the second file.The second file can be presented to the client, such as the clientcomputing device 124, or stored in the database on the server 114, asdisclosed herein.

As noted above, the server 112 can store the second file before thepopulating or retrieve the second file via the DBMS hosted on the server114 from the database stored on the server 114. Also, note that theserver 112 can generate the second file before the populating, whetherimmediately before or not immediately before. Also, note that the secondfile may be an original file or a copy of another file, whether the copyis generated via the server 112 or the server 114. Additionally, notethat the server 112 or the server 114 can generate the second file inresponse, whether immediate or not, to receiving the second input.Moreover, the second file can comprise a unique identifier before theinserting. For example, the unique identifier can be a barcode, a QRcode, an alphanumeric string, or an image. For example, the server 112or the server 114 can generate, retrieve, copy, or otherwise access thesecond file based on the unique identifier. In addition, if the pagecontains an alphanumeric or image content, such as graphical content,then the server 112 or the server 114 can be configured to filter out oravoid including such content in the second file when generating thesecond file, such as for a streamlined appearance when the second fileis presented, displayed, or printed. In some embodiments, the server 112or the server 114 may serve the second file to the client, such as theclient computing device 124, where the second file comprises anelectronic signature field that is ready to receive an electronicsignature from the client. For example, such electronic signature may beuseful for a network-based intake of a mortgage or insurance applicationand the first statement and the second statements must matchword-for-word what has been previously submitted to a government agency,such as electronically. For example, where the first statement and thesecond statement are literally recited in a third file in a first order,such as when previously submitted, the third file is generated beforethe second file and before the page is served with the first label andthe first input element. The page may display the first statement andthe second statement in a second order, where the first order and thesecond order are different orders, although identical orders arepossible as well. Further, note that the second file can be generatedupon receiving a submit input, such as via an activation of a button orhyperlink on the page, or without receiving a submit input, such as uponreceiving a data input from the client, such as alphanumeric or Boolean,or reaching a threshold data point in the worksheet, such as a specificstatement cell or logic cell. For example, the button can dynamicallychange from inactive or invisible to active or visible based onspreadsheet, such as upon reaching a threshold data point in theworksheet, such as a specific statement cell or logic cell. For example,the page can comprise a webpage with a dynamically updated form,including labels and fields. The page can contain a submission visualelement, such as a button, programmed to activate an upload of the firstinput or the second input from the client to the application server 112,such as for storage in a record of the server 114, where the record canbe subsequently accessed, such as via the DBMS as requested via theserver 112, for generating the second file. Note that medical oremployment application can be intaken similarly, as disclosed herein.

In an embodiment, the server 112 may receive a first file containing aspreadsheet. The server 112 may receive the first file via the clientcomputing device or may retrieve the first file from a database (checkin the first file as described above). The spreadsheet may comprise afirst row and a second row. Each row may comprise a statement cellcomprising a statement, a data type cell comprising a data typeidentifier, a logic cell comprising logic, a field cell comprising afield identifier. The server 112 may receive cell inputs for each row inthe spreadsheet. For example, the input data for the first statementcell may be “what is your date of birth.” The inputted data for the datatype cell may be “string.” The inputted data may be metadata for thefirst row and the second row. The first and second row may includeinformation corresponding to a first and second component in a graphicaluser interface (GUI). In some embodiments, the spreadsheet may be storedin a database (e.g., an internal or external database) and the server112 may receive an identification of the spreadsheet and a request toretrieve said spreadsheet. For example, the spreadsheet may be storedlocally on the client computing device 124 or other computing componentsdescribed in FIG. 1 (e.g., workstation 118 and terminal 120). In someembodiments, the spreadsheet may be stored onto the same computingdevice on which the server renders the GUI. For example, the clientcomputing device 124 may contain the spreadsheet used by the server 112to dynamically render the GUI. In some other embodiments, thespreadsheet may be partially stored onto more than one computing devicesas a security measure to combat unwanted data intercepts.

Based on the inputted data, the server 112 may dynamically render a GUIcomprising a first component based on a rendering request received fromthe client computing device 124 or other computing devices (e.g.,workstation 118 and terminal 120). For example, the GUI may include afirst label and a first input element. The first label may be the firststatement sourced from and corresponding to the first statement cell.The first input element may be configured according to the first datatype identifier sourced from and corresponding to the first data typecell. For example, the GUI may display a question “what is your date ofbirth” and a text box next to it where the client can type his/her dateof birth in the text box. In other examples, the GUI may display a radiobutton or a drop down box for the same question based on the clientindicating a desire for a radio button or a drop down box in thespreadsheet.

In some embodiments, the server 112 may render the GUI on a webpagedisplayed on the client computing device 124. The server 112 may haveaccess to one or more databases or pre-stored web-based interfaces, suchas webpages, comprising a number of preconfigured sub-interfaces, orcontainers, dynamically populated from the data analyzed and anonymizedby the server 112. For example, the above-mentioned webpages may containcode, such as HTML or PHP, presenting a website of any number ofwebpages having a common “look-and-feel.” One or more output or resultsdisplay webpages may contain additional code for containers, where thecontainer code displays information or data (e.g., a questionnaire) thatis configured to be dynamically and continuously generated (e.g.,continuous and modular generation of the GUI based on user inputs). Theserver 112 may populate the sub-interfaces (containers) of the webpagewith the appropriate components based on the spreadsheet, while thewebpage display is configured to maintain the website's commonaesthetic. The server 112 may modify the HTML code based on the receivedmetadata from the spreadsheets in order to render the GUI.

The server 112 may receive a first input. For example, the client mayinput the requested date of birth in text box of the GUI displayed onthe client device. After receiving the first input, the server 112 mayevaluate the first input against a first logic included in the firstrow. If the first input is corresponding to the first logic, the server112 may dynamically render a second component of GUI corresponding tothe second row. The server 112 may render the GUI to include a secondlabel and a second input element. The second label may be the secondstatement sourced from and corresponding to the second statement cell.The first input element may be configured according to the second datatype identifier sourced from and corresponding to the second data typecell. For example, the server 112 may determine if the client is morethan 18 years old to determine if the client is an adult. Based on thedetermination, the server 112 may provide different options depending onthe application. For example, the server 112 may determine the client ismore than 18 years old, and the server 112 may render the secondcomponent to ask if the client is married. The GUI may display aquestion “are you married” and a Boolean type input element (e.g., aradio button with options of “yes” and “no”) next to it.

The server 112 may receive a second input. For example, the server 112may receive the marital data from the client by extracting the inputdata from the second input element. The server 112 may evaluate thesecond input against a second logic in the second row and render moreuser interface components based on the evaluation results. There may beany number of rows. For example, the second row may call a third row,which may call a fourth row. The server 112 may also display other filesbased on the logic from the spreadsheet. For example, the spreadsheetmay require the server 112 to display different disclaimers based ondifferent answers received form the client. For example, if the server112 receives an input indicating that the client lives in New York andthe client is under 18, the server 112 may be required to displaycertain disclaimers. The server 112 may then query a database based onthe logic from the spreadsheet (e.g., query an internal or externaldatabase based on the disclaimer identifier indicated within thespreadsheet) and retrieve a file including the disclaimer and rendersaid disclaimer on the GUI.

After the server 112 renders all rows, or the logic reaches the end ofprocessing, the server 112 may generate a second file by inserting theinputs into the corresponding field of the second file. For example, theserver 112 may insert the first input into a first field of the secondfile based on the first field identifier, and insert the second inputinto the second file based on the second file identifier. For example,the server 112 may insert the inputted data of birth into acorresponding field in the first row of the second file, and theinputted marital status into a corresponding field of the second row ofthe second file. In some embodiments, the server 112 may generate thesecond file by replicating exactly what the client has viewed on theGUI. For example, all the boxes (e.g., radio buttons, drip downs,disclaimers, and other GUI components) may be the same. In some otherembodiments, the server 112 may only retrieve the answers (e.g.,inputted by the client) and generate the second file based on saidinputs. The server 112 may also generate a third file (e.g., a reportfile) indicating whether the inputs are consistent with the logic of thespreadsheet. For example the report file may indicate (e.g., flag) theage of the client if the client is younger than 18 years of age. Theserver 112 may transmit the report file upon in real time or in batches(e.g., upon termination of one data intake).

FIG. 4 shows a flowchart of an embodiment of a process for inheritancebased data structure generation according to the present disclosure. Aprocess 400 includes a plurality of blocks 402-422. The process 400 canbe performed via the topology 100 of FIG. 1 , in whole or in part.

In a block 402, the server 112 creates a first worksheet in aspreadsheet, as disclosed herein. For example, the spreadsheet can benetwork-based, such as Google Docs or MS Office 365. The first worksheetcomprises a first row. For example, the spreadsheet can be presented ona network page, such as a webpage, over the LAN 116 or the WAN 102.

In a block 404, the server 112 receives a plurality of first row cellinputs from a client, such as the workstation 118, as disclosed herein.For example, the first row cell inputs can include a first statement, afirst data type identifier, a first logic, a first field identifier, ora first key.

In a block 406, the server 112 populates the first row of the firstworksheet with the first row cell inputs, as disclosed herein. Forexample, the server 112 populates the first row of the first worksheetsuch that the first row comprises a first statement cell comprising thefirst statement, a first data type cell comprising the first data typeidentifier, a first logic cell comprising the first logic, a first fieldcell comprising the first field identifier, or the first key cellcomprising the first key. Note that such cell order is one example andother cell orders are possible, in any permutational or combinatorymanner, such as the first key cell being positioned in a first column ofa worksheet of the spreadsheet. Further, note that at least two of suchfirst row cells can be a single cell.

In a block 408, the server 112 creates a second worksheet with a secondrow in the spreadsheet, as disclosed herein. For example, the clientrequests the server 112 to create the second worksheet, such as via acreate worksheet request.

In a block 410, the server 112 may inherit at least some cell contentfrom the first row of the first worksheet into the second row of thesecond worksheet. Note that more than one row inheritance is possible,such as one-to-one, one-to-many, many-to-one, or many-to-many. Duringsuch creation, the second worksheet may inherit data or format from thefirst worksheet, such as the first row, whether on a columnar, row, orcellular basis, as disclosed herein. For example, the second row maycomprise a second statement cell comprising the first statement, asecond data type cell comprising the first data type identifier, asecond logic cell comprising the first logic, a second field cellcomprising the first field identifier, or a second key cell comprisingthe first key. Further, note that at least two of such second row cellscan be a single cell. Note that such cell order is one example and othercell orders are possible, in any permutational or combinatory manner,such as the second key cell being positioned in the first column or thesecond column of the second worksheet. Also, note that a cell in thefirst row and a cell in the second row can be shaped or sized identicalto or different from each other. Note that the first row and the secondrow can be immediately adjacent to each other or spaced apart from eachother via a row in-between. Note that cell order, size, shape, or othercell attributes in rows can be inherited.

Note that such inheritance, whether single, multiple, or multilevel, issimilar to inheritance in object-oriented programming, where a childobject inherits a property/attribute/feature from a parent object.Likewise, a child worksheet can be based on another worksheet (parentworksheet), whether in a same or different spreadsheet or file ordatabase or record or data structure, whether sourced locally or througha network, using a same implementation or specifying implementation tomaintain a same behavior (realizing an interface or inheritingbehavior). Such type of inheritance is a mechanism for code reuse and toallow independent extensions of an original worksheet or spreadsheet.For example, such relationships give rise to a worksheet hierarchy. Forexample, a child worksheet can inherit a row from a parent worksheet,such as responsive to a user input or automatically responsive to adetection of a trigger or a detection of a condition being met or adetection of a threshold being satisfied, and then such row can bemodified or appended to, such as via a population of another cell inthat row, such as responsive to a user input or automatically responsiveto a detection of a trigger or a detection of a condition being met or adetection of a threshold being satisfied. For example, a child worksheetcan inherit a first row from a parent worksheet and then a second rowcan be added, whether above or below the first line, where a content ofthe second row is responsive to or based on a content of the first rowor vice versa. Note that more than two worksheets are possible, in anytype of hierarchical branching. For example, the server 112 can maintainor generate a hierarchical worksheet map can be served, such aspresented via display or print, so that a worksheet tree is displayed,where each of the nodes corresponds to a worksheet. This map allows auser to easily navigate inheritance hierarchy.

In a block 412, the server 112 receives a second row cell input, such asfrom the workstation 118 over the LAN 116. The second row cell input cantrigger the server 112 for perform at least one of a block 414, a block416, or a block 418. For example, all of the blocks 414, 416, and 418can be performed; and in some embodiments, less than all the blocks canbe performed.

In the block 414, the second row cell input can append to the secondrow. For example, such appending can include an addition or removal of acell/content after last populated cell in the second row. For example,such appending can further define a child worksheet from a parentworksheet.

In the block 416, the second row cell input can modify at least one ofthe first row cell inputs in the second row. For example, suchmodification can edit at least one of the second statement cellcomprising the first statement, the second data type cell comprising thefirst data type identifier, the second logic cell comprising the firstlogic, the second field cell comprising the first field identifier, orthe second key cell comprising the first key. Such edit can includeamending or deleting, in content or format. For example, such appendingcan further define a child worksheet from a parent worksheet.

In the block 418, the second row cell input can add a third row to thesecond worksheet. For example, the third row, which may be a new row,may further add content/rules to the second worksheet. The third row maybe added, as disclosed herein, whether immediately or not immediatelyadjacent to the second row. For example, such adding can further definea child worksheet from a parent worksheet. However, note that removal ofrows may be possible as well.

In a block 420, the server 112 serves, such as dynamically, a page withan input field based on the second row, as disclosed herein. For theexample, the server 112 may serve the page to the client computingdevice 124 over the WAN 102 based on a request received from the clientcomputing device 124 over the WAN 102. For example, upon receiving thepage request from the client, such service can comprise the servergenerating and then sending a set of executable instructions, such asmarkup language code, such as HTML or XML, to the client for execution,such as locally, to present the page, such as via a browser running onthe OS of the client. Note that such service can comprise the servergenerating and then sending the page to the client for presentation,such as locally, such as via a browser running on the OS of the clientor non-browser app running on the OS, such as a mobile non-browser app.Note that such service can comprise an authenticated session between theserver 112 and the client, such as for security purposes. Theauthenticated communication session can be via HTTPS protocol. Theauthenticated communication session can be via login/password orbiometrics.

The page visually presents, as dynamically generated, a label and aninput element, such as a text entry box, a checkbox, a slider, a button,a dropdown menu, a sliding scale, or another other visual element. Thelabel comprises the first statement, such as an alphabetic string,sourced from the second statement cell, as modified if at all in thesecond worksheet, based on dynamic page generation, such as via thefirst key, as modified if at all in the second worksheet. The inputelement is configured for an input, such as via a radio or option buttonor a dropdown menu, according to the first data type identifier sourcedfrom the second data type cell in the second worksheet, as modified ifat all in the second worksheet, based on dynamic page generation.

In a block 422, the server 112 generates a data structure, such as afile, storing an input from the input field. The data structure can be atable, a list, a matrix, a grid, a queue, a stack, a deck, a quadtree,or others. For example, the file can comprise a productivity documentfile, such as an MS Word or Excel file, or a PDF document or a markuplanguage file, such as an HTML file. Note that the server 112 can storethe data structure before the storing of the input or retrieve the datastructure via the DBMS hosted on the server 114 from the database hostedon the server 114. Also, note that the server 112 can generate the datastructure before the storing, whether immediately before or notimmediately before. Also, note that the data structure may be anoriginal file or a copy of another data structure, whether the copy isgenerated via the server 112 or the server 114. Additionally, note thatthe server 112 or the server 114 can generate the data structure inresponse, whether immediate or not, to receiving the input. Moreover,the data structure can comprise a unique identifier before theinserting. For example, the unique identifier can be a barcode, a QRcode, an alphanumeric string, or an image. For example, the server 112or the server 114 can generate, retrieve, copy, or otherwise access thedata structure based on the unique identifier.

FIG. 5 shows a flowchart of an embodiment of a first process fordocument management according to the present disclosure. A process 500includes a plurality of blocks 502-514. The process 500 can be performedvia the topology 100 of FIG. 1 , in whole or in part.

In a block 502, the server 112 checks-out a spreadsheet with a first rowand a second row to a first client. For example, the server 112, oralong with the server 114, may host a network-based document managementsystem, such as MS SharePoint, MS Office 365, FileSite, or Google Drive.The document management system may provide a document check-in/check-outfunctionality in order to prevent a conflict where multiple users maywant to concurrently modify the file comprising the spreadsheet. Forexample, the server 112 may serve a user interface, such as a GUI, tothe first client, such as the workstation 118, such as over the LAN 116,as disclosed herein. The user interface comprises a check-out elementconfigured for a check-out input related to a file, such as a file nameidentifier for user selection or a checkbox, and a check-in elementconfigured for a check-in input related to the file, such as a file nameidentifier for user selection or a checkbox, as disclosed herein. Forexample, the file can be checked-out by opening the file and the filecan be checked-in by closing the file, as disclosed herein. The filecomprises the spreadsheet with the first row and the second row, asdisclosed herein. For example, the server 112 receives the check-outinput from the first client, such as over the LAN 116, and in response,the server 112 checks-out the file such that the file cannot be modifiedby a second client, such as the terminal 120, until the server 112receives the check-in input from the first client. The check-out requestmay be before the server 112 serves the page with a label and an inputelement to a client, such as the client computing device 124. In anembodiment, the workstation may check out a file stored locally or ontoany of the databases illustrated in FIG. 1 . The checked-out spreadsheetmay be used to dynamically generate a GUI on a client computing device(e.g., client computing device 124).

In a block 504, outputs a check-out message to the second client. Forexample, the server 112 serves, such as over the LAN 116, the check-outmessage to a second client, such as the terminal 120, when the secondclient attempts to access the file. Therefore, the server 112 prevents,such as via file locking/privilege control/permission (read, write,delete) control, the second client from accessing the file when thesecond client attempts to access the file. The check-out message mayinform the second client that the file is checked-out and may notify whothe file is check-out to, such as the first client.

In a block 506, the server 112 receives a set of first row cell inputsand a set of second row cell inputs, as disclosed herein. For example,the set of first row cell inputs can comprise a first statement, a firstdata type identifier, a first logic, a first field identifier, or afirst key. For example, the set of second row cell inputs can comprise asecond statement, a second data type identifier, a second logic, asecond field identifier, or a second key. In an embodiment, the firstclient operating the workstation 118 may modify the checked outspreadsheet in order to customize the GUI to be generated.

In a block 508, the server 112 populates the first row with the firstset of inputs and the second row with the second set of inputs. Forexample, the server 112 populates the first row of the worksheet suchthat the first row comprises a first statement cell comprising the firststatement, a first data type cell comprising the first data typeidentifier, a first logic cell comprising the first logic, a first fieldcell comprising the first field identifier, or the first key cellcomprising the first key. Likewise, the server 112 populates the secondrow of the worksheet such that the second row comprises a secondstatement cell comprising the second statement, a second data type cellcomprising the second data type identifier, a second logic cellcomprising the second logic, a second field cell comprising the secondfield identifier, or the second key cell comprising the second key. Notethat such population can be original population or modifying population.For example, the modifying population can modify at least one of thefirst or second statement, the first or second data type identifier, orthe first or second logic based on a write request from the first clientduring the modifying, as disclosed herein. For example, the writerequest may enable an addition, deletion, modification, editing,appending or any other data amendment to the spreadsheet, on cellular,columnar, or row level, as disclosed herein.

In a block 510, the server 112 checks-in the spreadsheet. For example,the server 112 may receive a check-in request, such as a message, fromthe first client, such as over the LAN 116. The check-in request may bebefore the server 112 serves the page with the label and the inputelement, as noted above. In response to the check-in request, the server112 checks-in the spreadsheet from the first client such that the secondclient can access the spreadsheet. Such check-out and check-in processcan also occur when the server 112 is serving pages to clients, such asfor data integrity purposes.

Note that the block 504 is sized to correspond with the blocks 506, 508,and 510, such as for parallel processing purposes. As noted above, insome embodiments, the application server 112 comprises a processorhosting a plurality of cores, as disclosed herein. Therefore, during theblock 504, the application server 112 may be parallel processing blocks506, 508, and 510. This provides for more efficient use of theapplication server 112.

For example, responsive to the server 112 providing a GUI with acheck-in/check-out functionality to the first client, such as theworkstation 118, over the LAN 116, and a receiving a check-in requestfrom the first client based on the GUI, the server 112 may add a new ormodified file to a document library or a list to replace a previousversion of the file, where the file comprises the spreadsheet. Likewise,responsive to the server 112 providing a GUI with a check-in/check-outfunctionality to a client, such as the workstation 118, over the LAN116, and a receiving a check-out request from the client based on theGUI, the server 112 may get a version of the file in a file list or afile library, where the file comprises the spreadsheet. Therefore, viachecking-out the file, a user of the client can prevent other users frommodifying/editing that a content of the file. Similarly, via checking-inthe file, the user of the client can allow others to edit the content ofthe file, without needing to worry about overriding changes that othershave made. Note that when the file is checked out to the user of theclient, then that user can work on that file, and other users cannot.Consequently, other users must wait for the user to check-in the fileagain (that is, perform a check-in) before the other users canmodify/edit the file. While the file is checked-out, other users may ormay not see only a last version of the file that was checked-in via theuser of the client and therefore the other users may or may not see achange that the user of the client, which is a current user of the file,has made on the file while the file has been checked-out. For example,the server 112 may receive the check-in input from the first clientafter the modifying, and in response to such receipt, the server 112 maycheck-in the file such that the file can be modified by the secondclient, as disclosed herein.

In a block 512, the server 112 dynamically generates a page based on thefirst row and the second row. For example, the server 112 serves thepage (on the client computing device 124) with a first input field basedon the first row and a second input field based on the second row, asdisclosed herein. The server 112 may serve the page to the clientcomputing device 124 over the WAN 102 based on a request received fromthe client computing device 124 over the WAN 102. For example, uponreceiving the page request from the client, such service can comprisethe server generating and then sending a set of executable instructions,such as markup language code, such as HTML or XML, to the client forexecution, such as locally, to present the page, such as via a browserrunning on the OS of the client. Note that such service can comprise theserver generating and then sending the page to the client forpresentation, such as locally, such as via a browser running on the OSof the client or non-browser app running on the OS, such as a mobilenon-browser app. Note that such service can comprise an authenticatedsession between the server 112 and the client, such as for securitypurposes. The authenticated communication session can be via HTTPSprotocol. The authenticated communication session can be vialogin/password or biometrics.

The page visually presents, as dynamically generated, a label and aninput element, such as a text entry box, a checkbox, a slider, a button,a dropdown menu, a sliding scale, or another other visual element. Thelabel comprises the first or second statement, such as an alphabeticstring, sourced from the first or second statement cell, as modified ifat all in the spreadsheet, based on dynamic page generation, such as viathe first or second key, as modified if at all in the spreadsheet. Theinput element is configured for an input, such as via a radio or optionbutton or a dropdown menu, according to the first or second data typeidentifier sourced from the first or second data type cell in thespreadsheet, as modified if at all in the spreadsheet, based on dynamicpage generation.

In a block 514, the server 112 populates a data structure, such as afile, based on an input from the page, such as via an input field. Thedata structure can be a table, a list, a matrix, a grid, a queue, astack, a deck, a quadtree, or others. For example, the file can comprisea productivity document file, such as an MS Word or Excel file, or a PDFdocument or a markup language file, such as an HTML file. Note that theserver 112 can store the data structure before the storing of the inputor retrieve the data structure via the DBMS hosted on the server 114from the database hosted on the server 114. Also, note that the server112 can generate the data structure before the storing, whetherimmediately before or not immediately before. Also, note that the datastructure may be an original file or a copy of another data structure,whether the copy is generated via the server 112 or the server 114.Additionally, note that the server 112 or the server 114 can generatethe data structure in response, whether immediate or not, to receivingthe input. Moreover, the data structure can comprise a unique identifierbefore the inserting. For example, the unique identifier can be abarcode, a QR code, an alphanumeric string, or an image. For example,the server 112 or the server 114 can generate, retrieve, copy, orotherwise access the data structure based on the unique identifier. Thefile (e.g., data structure) may represent the page presented on theclient computing device 124 (block 512) and may include all theresponses (e.g., inputs) received from the client computing device 124.

In some embodiments, the file with the spreadsheet can be stored localon a client, such as on the client or a memory device coupled to theclient, such as an external hard disk, or an optical drive, anetwork-based storage drive, or a flash drive. For example, the filewith the spreadsheet can be stored remote from the client, such as anetwork-based file hosting service, which may provide a cloud-basedstorage, file synchronization, personal cloud, or client software. Forexample, the network-based file hosting service may allow a user tocreate a folder on the user's computer, where the folder issynchronized, whether in real-time or periodically, with thenetwork-based file hosting service such that the folder appears to besame folder (with same contents) regardless of which computing device isused to view the folder. For example, the network-based file storageservice can comprise Dropbox or Google Drive. Therefore, the file withthe spreadsheet can be locally processed, whether additional to oralternative to server processing.

FIG. 6 shows a flowchart of an embodiment of a second process fordocument management according to the present disclosure. A process 600includes a plurality of blocks 602-616. The process 600 can be performedvia the topology 100 of FIG. 1 , in whole or in part. The process 600may be performed via the server 112 hosting a spreadsheet processingengine, which may comprise a document check-in/check-out component, apage generation component, and a data structure generation component.For example, a component may comprise a module, an engine, a function, aroutine, a class, an object, or others. The process 600 may be useful toensure data integrity for the spreadsheet processing engine, such asduring dynamic page generation. The process 600 may also be useful totesting how a page is served or a data structure is generated.

In a block 602, the server 112 unavails a spreadsheet with a firstpopulated row and a second populated row to a first client. The firstpopulated row or the second populated row may be populated, as disclosedherein, such as via the first client before the unavailing. Also, notethat such unavailing can be client-activated/triggered, such as via thefirst client communicably interfacing with the first server, such viacheck-in/check-out process. Further, such unavailing can be performedvia a network security system process, such as via the firewall 106 orthe firewall 110, a hiding of the spreadsheet process from the firstclient, such as the firewall 106 or the firewall 110, a documentmanagement system or the document check-in/out component, which may beunitary with the document management system. Therefore, via checking-outthe spreadsheet to the first client, the server 112 prevents the firstclient from modifying/editing that a content of the spreadsheet, whichmay even include reading the content.

In a block 604, the server 112 outputs an unavailable message, such as acheck-out message, to the first client. For example, the server 112serves, such as over the LAN 116, the unavailable message, such as aspreadsheet unavailable message, to the first client when the firstclient attempts to access the spreadsheet. Therefore, the server 112prevents, such as via file locking/privilege control/permission (read,write, delete) control, the first client from accessing the spreadsheetwhen the first client attempts to access the spreadsheet. Theunavailable message may inform the first client that the spreadsheet ischecked-out and may notify whom the spreadsheet is checked-out to, suchas the server 112.

In a block 606, the server 112 serves a dynamic page to a second clientbased on the first populated row and the second populated row. Forexample, the server 112 dynamically generates the page based on thefirst populated row and the second populated row. For example, theserver 112 serves the page with a first input field based on the firstrow and a second input field based on the second row, as disclosedherein. The server 112 may serve the page to the second client, such asthe client computing device 124 or the terminal 120, over the WAN 102based on a request received from the second client over the WAN 102. Forexample, upon receiving the page request from the second client, suchservice can comprise the server generating and then sending a set ofexecutable instructions, such as markup language code, such as HTML orXML, to the second client for execution, such as locally, to present thepage, such as via a browser running on the OS of the second client. Notethat such service can comprise the server 112 generating and thensending the page to the second client for presentation, such as locally,such as via a browser running on the OS of the second client ornon-browser app running on the OS, such as a mobile non-browser app.Note that such service can comprise an authenticated session between theserver 112 and the second client, such as for security purposes. Theauthenticated communication session can be via HTTPS protocol. Theauthenticated communication session can be via login/password orbiometrics.

The page visually presents, as dynamically generated, a label and aninput element, such as a text entry box, a checkbox, a slider, a button,a dropdown menu, a sliding scale, or another other visual element. Thelabel comprises the first or second statement, such as an alphabeticstring, sourced from the first or second statement cell, as modified ifat all in the spreadsheet, based on dynamic page generation, such as viathe first or second key, as modified if at all in the spreadsheet. Theinput element is configured for an input, such as via a radio or optionbutton or a dropdown menu, according to the first or second data typeidentifier sourced from the first or second data type cell in thespreadsheet, as modified if at all in the spreadsheet, based on dynamicpage generation.

In a block 608, the server 112 generates a data structure based on aninput from the dynamic page. For example, the server 112 populates thedata structure, such as a file, based on the input from the page, suchas via an input field. The data structure can be a table, a list, amatrix, a grid, a queue, a stack, a deck, a quadtree, or others. Forexample, the file can comprise a productivity document file, such as anMS Word or Excel file, or a PDF document or a markup language file, suchas an HTML file. Note that the server 112 can store the data structurebefore the storing of the input or retrieve the data structure via theDBMS hosted on the server 114 from the database hosted on the server114. Also, note that the server 112 can generate the data structurebefore the storing, whether immediately before or not immediatelybefore. Also, note that the data structure may be an original file or acopy of another data structure, whether the copy is generated via theserver 112 or the server 114. Additionally, note that the server 112 orthe server 114 can generate the data structure in response, whetherimmediate or not, to receiving the input. Moreover, the data structurecan comprise a unique identifier before the inserting. For example, theunique identifier can be a barcode, a QR code, an alphanumeric string,or an image. For example, the server 112 or the server 114 can generate,retrieve, copy, or otherwise access the data structure based on theunique identifier. Therefore, since the server 112 checks-out thespreadsheet to the spreadsheet processing engine, the server 112 ensuresthat the page is dynamically generated properly, while minimizing dataintegrity issues and maximizing data accuracy, which may arise if thespreadsheet is edited while the page is being served. Likewise, sincethe server 112 checks-out the spreadsheet to the spreadsheet processingengine, the server 112 ensures that the data structure is generatedproperly, while minimizing data integrity and maximizing data accuracy.

In some embodiments, the file with the spreadsheet can be stored localon a client, such as on the client or a memory device coupled to theclient, such as an external hard disk, or an optical drive, anetwork-based storage drive, or a flash drive. For example, the filewith the spreadsheet can be stored remote from the client, such as anetwork-based file hosting service, which may provide a cloud-basedstorage, file synchronization, personal cloud, or client software. Forexample, the network-based file hosting service may allow a user tocreate a folder on the user's computer, where the folder issynchronized, whether in real-time or periodically, with thenetwork-based file hosting service such that the folder appears to besame folder (with same contents) regardless of which computing device isused to view the folder. For example, the network-based file storageservice can comprise Dropbox or Google Drive. Therefore, the file withthe spreadsheet can be locally processed, whether additional to oralternative to server processing.

In a block 610, the server 112 avails the spreadsheet to the firstclient. Such availing can be performed via a network security systemprocess, such as via the firewall 106 or the firewall 110, an un-hidingof the spreadsheet process from the first client, such as the firewall106 or the firewall 110, a document management system or the documentcheck-in/out component, which may be unitary with the documentmanagement system. Therefore, via checking-in the file from thespreadsheet processing engine, the server 112 enables the first clientto modify/edit a content of the spreadsheet, which may even includingreading the content. Also, note that such availing can beclient-activated/triggered, such as via the first client communicablyinterfacing with the first server, such via check-in/check-out process.For example, such client activation/trigger can be an interrupt command,which may interrupt page service or data structure generation.

In a block 612, the server 112 checks-out the spreadsheet to the firstclient, as disclosed herein. Therefore, a third client, such as theterminal 120, is unable to check-in the spreadsheet at least formodifying/editing, such as for data integrity purposes. For example, thechecking-out can be managed via the document management system, asdisclosed herein.

In a block 614, the server 112 modifies the spreadsheet via the firstclient, as disclosed herein. For example, such modification may be ofthe blocks 414-418.

In a block 616, the server 112 checks-in the spreadsheet from the firstclient. The spreadsheet is checked-in from the first client. Therefore,the third client or the spreadsheet processing engine is able tocheck-out the spreadsheet at least for modifying/editing or page serviceor data structure generation. For example, the checking-in can bemanaged via the document management system, as disclosed herein.Therefore, the spreadsheet processing engine may perform the block 602.Although FIG. 6 appears to show an infinite loop, note that the process600 can be interrupted by the interrupt, as disclosed herein, or otherprocess interrupt procedures, such as updates or maintenance or by thefirst client. The embodiment illustrated in FIG. 6 , allows the page tobe dynamically rendered to the second client without being modified bythe first client while the page is being viewed by the second client.For example, the first client may not have access to the spreadsheetwhile the second client is interacting with the page. The first clientmust wait until the second client has completed interacting and theserver 112 has generated the data structure (block 608).

FIGS. 7A-B show a screenshot of an embodiment of a spreadsheetcontaining a parent worksheet being active for data input as selectedvia a parent worksheet tab and a child worksheet being inactive for datainput as not selected via a child worksheet tab according to the presentdisclosure. FIG. 7C shows a graphical user interface dynamicallyrendered based on the spreadsheets illustrated in FIGS. 7A-B. Asillustrated in FIG. 7A, the parent spreadsheet comprises of data neededto dynamically generate a GUI. For example, column B illustrates a keycell that identifies the row (e.g., the field to be rendered); Column Cillustrates a question level that may be modified by the user; column Dillustrates a statement cell (e.g., the question or the statement to berendered); column E represents the logic of the response (e.g., acceptedresponses). In an embodiment, the server 112 uses row #2 (e.g., key#00201) to render component 710 on GUI 700. The server 112 uses cell D-2to populate the text component 720, uses cell K-2 to render the helpbutton 740 (e.g., when the use interacts with the help button 740, theGUI 700 displays the text from cell K-2), uses cell L-2 to render radiobuttons 730. Some of the statements may comprise a question and theserver 112 may present a question in a reflexive manner based on a rulecontrolling when a question will or will not be asked. For example, oncethe server 112 receives an input from the client computing device 124,the server 112 renders the next GUI component based on the informationprovided by column N and the conditions provided by column O. Forexample, if the server 112 receives a “No, it's for other purposes”input to radio buttons 730 (as outlines in cell O-3), the server 112will display row #3 (e.g., Key #00202) based on the receivedinstructions from cell N-3. As illustrated in FIG. 7C, the answerreceived by the server 112 was “yes.” As a result, the server 112renders row #2 instead of row #3. Parent worksheet also illustrates theaesthetic preferences for rendering the GUI 700. For example, cell J-2instructs the server 112 as to the width of the component 710. Theworksheets (the parent and the child worksheets) may also controllateral or longitudinal length, color/contrast, position, font, shape,size, or other relevant attribute of any GUI component.

FIG. 8A shows a screenshot of an embodiment of a spreadsheet containinga parent worksheet being inactive for data input as not selected via aparent worksheet tab and a child worksheet being active for data inputas selected via a child worksheet tab according to the presentdisclosure. FIG. 8B shows a graphical user interface dynamicallyrendered based on the spreadsheet illustrated in FIG. 8A. The childspreadsheet illustrated is FIG. 8A may be a spreadsheet generated by theserver 112 using the object-oriented programming concept of“inheritance” where the rows of the child worksheet inherit theproperty, attribute, and features of the parent worksheet (or anotherworksheet as directed by the user). For example, in the spreadsheetillustrated in FIG. 8A, rows with a prefix of B inherit properties oftheir corresponding rows from the parent worksheet (FIG. 7A-B). The usermay have the ability to override or modify these properties. If leftblank (e.g., row #3) the server 112 may render the GUI based on theproperties of the indicated key (e.g., row #4 of the parent worksheet).The server 112 may use the same method (shown above in FIG. 7A-C) torender a GUI that corresponds to the child worksheet. For example, theserver 112 uses the cells of the child worksheet to render GUI 800.

FIG. 9 shows a screenshot of an embodiment of a single network pagegenerated based on a spreadsheet according to the present disclosure.The single network page is scrollable along a vertical plane. The singlenetwork page depicts various fields as generated via the worksheets ofFIGS. 7A-B. Screenshot 900 may depict the components of GUI 700 and mayinclude the inputs received from the client computing device (notshown). Furthermore, screenshot 900 may reorganize the GUI components ina way that is customizable by the user/client. For example, screenshot900 may be generated to replicate the exact order of components andquestions viewed by the user. The screenshot 900 may also designateand/or organize each component by its respective “section” (e.g., columnM of the parent worksheet) or any other attribute of the worksheet thatthe server 112 has used to render the GUI.

FIG. 10 shows an embodiment of a table of reflexive questions and rules,where the reflexive questions appear in a dynamically adjusted networkpage based on the rules, where the rules determine when a question willor will not be asked according to the present disclosure. The server 112may generate the table of reflexive questions based on the worksheetthat the server 112 has used to render the GUI presented on the clientcomputing device. For example, table 1000 corresponds to the parentworksheet illustrated in FIGS. 7A-B and illustrates the logic used togenerate GUI 700. Table 1000 may comprise a plurality of columns and aplurality of rows. As shown, the question number column lists the key (aquestion number), the logic column lists the logic (a rule defining forwhen a question will or will not be asked i.e. controlling a reflexivequestion aspect of the spreadsheet), the statement column lists thestatement (a question string) and the input type column lists the inputtype (an option for a response to a question string). For example, if ananswer to a question 1 (key is 1), “Are you the person being insured?”is “my spouse” or “my partner or fiancé”, then a reference to “your”from question 2 (key is 2.) and beyond will change to “your spouse” or“your partner”. If the answer to question 101 (key is 101) “my spouse”or “my partner or fiancé,” then a reference to “your” from questionnumber 102 (key is 102) through 191 (key is 191) will change to “yourspouse” or “your partner”.

FIG. 11 shows a flowchart of an embodiment of a process ofreconstructing a reflexive questionnaire based on a set of metadataaccording to the present disclosure. In particular, a process 1100 canbe performed via the topology 100 of FIG. 1 , in whole or in part.

In block 1102, a spreadsheet is populated with a set of rules and aversion identifier. The spreadsheet is as described above. Thespreadsheet is populated as described above. The set of rules is asdescribed above. For example, the set of rules can include a logic, suchas a Boolean logic or others. The version identifier includes a symbolor a set of symbols that can identify a version of the set of rules. Forexample, the version identifier can include at least one of analphanumeric string, a barcode, an image, a sound, or others. Forexample, when embodied as the alphanumeric string, then the versionidentifier can be 2, 6/13/2012, February_3_2014, 31082017, or others.For example, the version identifier can relate to or include a date thespreadsheet is populated with the set of rules. For example, theapplication server 112 can present a user interface to a client, such asthe workstation 118 or the administrator terminal 120 or others, wherethe user interface is configured to receive the set of rules and theversion identifier from the client. For example, the user interface canbe presented as a web page or an app page. For example, the userinterface can present the spreadsheet. The version identifier can bepopulated at a new line of the spreadsheet, such as above, within, orbelow the set of rules, or appended to an existing rule within thespreadsheet. Note that the version identifier can be executable ornon-executable. Also, note that the spreadsheet can be configured tocheck for duplicates of the version identifier, such as when thespreadsheet is communicably link to a list of version identifiers, suchas in a file or another data structure.

In block 1104, the set of rules is executed from the spreadsheet asdescribed above.

In block 1106, a reflexive questionnaire is presented, where thereflexive questionnaire includes a set of questions generated based onthe set of rules as described above. The set of questions is associatedwith the version identifier, such as via the version identifier beingincluded in the reflexive questionnaire. For example, the applicationserver 112 can present a user interface to a client, such as the clientcomputing device 124, where the user interface contains the reflexivequestionnaire with the set of questions generated based on the set ofrules and where the set of questions is visually associated with theversion identifier. For example, the user interface can be presented asa web page or an app page.

In block 1108, a set of answers to the set of questions is received asdescribed above. For example, the application server 112 receive the setof answers from the client computing device 124. For example, the set ofanswers can include a set of textual data, a set of binary data, a setof image data, a set of sound data, or others.

In block 1110, the set of answers is stored as a set of metadata, whichcan be more efficient than storage in a PDF format. For example, the setof metadata can be hierarchical. For example, the application server 112can store the set of answers as the set of metadata in the databaseserver 114. The set of metadata can include descriptive metadata,structural metadata, administrative metadata, reference metadata,statistical metadata, or others. For example, the descriptive metadatadescribes a resource for purposes such as discovery and identification,and can include elements such as title, abstract, author, and keywords.For example, the structural metadata is metadata about containers ofdata and indicates how compound objects are put together, for example,how the set of answers are ordered to form hierarchies, and describestypes, versions, relationships and other characteristics of digitalmaterials. For example, the administrative metadata provides informationto help manage a resource, such as when and how the resource wascreated, file type and other technical information, and who can access.For example, the reference metadata describes contents and quality ofstatistical data. For example, statistical metadata can describeprocesses that collect, process, or produce statistical data. Forexample, the set of metadata can include a set of metadata tags. Forexample, the set of metadata can be structured according to a conceptusing a well-defined metadata scheme, including: metadata standards andmetadata models. Tools such as controlled vocabularies, taxonomies,thesauri, data dictionaries, and metadata registries can be used toapply standardization to the set of metadata. For example, the set ofmetadata can include a syntax, i.e., a set of rules created to structurefields/elements of the set of metadata. For example, a single metadatascheme may be expressed in a number of different markup or programminglanguage, each of which may involve a different syntax. For example, theset of metadata may be expressed as plaintext, XML, HTML, XHTML, aResource Description Framework (RDF), or others. For example, the set ofmetadata can include a metadata schemata that can be hierarchical innature where relationships exist between metadata elements and elementsare nested so that parent-child relationships exist between theelements. The metadata schemata can be one-dimensional, or linear, whereeach element is completely discrete from other elements and classifiedaccording to one dimension only. The metadata schemata can be twodimensional, or planar, where each element is completely discrete fromother elements but classified according to two orthogonal dimensions.For example, the set of metadata can be hypermapped, i.e., where ametadata schemata exceed a planar depiction, a hypermapping techniqueenables a display and view of metadata according to chosen aspect and toserve special views. For example, the set of metadata can be stored in asingle data structure or in a plurality of data structures, whetheridentical to or different from each other in structure or content. Theset of metadata can be stored either internally, in same file orstructure as data (this is also called embedded metadata), orexternally, in a separate file or field from described data. Forexample, a data repository, such as the database server 114, can storethe set of metadata detached from data, but can be designed to supportembedded metadata approaches. For example, when stored, then the set ofmetadata can be searchable, such as via text queries, image queries,sound queries, or others. For example, the set of metadata can be storedin a human-readable or binary form.

In block 1112, the version identifier is associated with the set ofmetadata. For example, the application server 112 can store the versionidentifier as the set of metadata within the database server 114. Forexample, the version identifier can be stored as part of the set ofmetadata or internal thereto or external thereto but associatedtherewith, such as via a pointer, a reference, or others. For example,the version identifier can be stored within the set of metadata. Notethat the version identifier can be associated with a plurality of setsof metadata. For example, the version identifier can associated with asecond set of metadata distinct from the first set of metadata (a secondset of answers).

In block 1114, a request is received, such as via the server 112 from aclient, such as the workstation 118 or the administrator terminal 120 orothers. For example, the server 112 can present a user interface to theclient, where the user interface is configured to receive a request fromthe client. The request can include a command to recreate the reflexivequestionnaire. The request can relate to the version identifier. Forexample, the spreadsheet is populated by a first client internal to anetwork as described above and the reflexive questionnaire is completedby a second client external to the network as described above and therequest is placed by a third client internal to the network as describedabove.

In block 1116, the version identifier is located based on the request.For example, the application server 112 can query the database server114 to search and locate the version identifier as stored therein.

In block 1118, the set of questions can be retrieved based on theversion identifier. For example, the application server 112 can querythe database server 114 or the spreadsheet to search, locate, and fetchthe set of questions based on the version identifier.

In block 1120, the set of metadata can be retrieved based on the versionidentifier. For example, the application server 112 can query thedatabase server 114 or the spreadsheet to search, locate, and fetch theset of metadata based on the version identifier.

In block 1122, the reflexive questionnaire with the set of questions andthe set of answers is recreated. For example, the application server 112can recreate the reflexive questionnaire with the set of questions basedon the version identifier and the set of answers based on the set ofmetadata responsive to the request. For example, the reflexivequestionnaire can be recreated in at least partially same visual formator content as presented in block 1106. For example, the reflexivequestionnaire can be recreated into a data structure, such as a file, anarray, a linked list, a web page, an app page, a PDF document, an HTMLdocument, an XML document, or others.

In block 1124, an action can be taken based on the reflexivequestionnaire as recreated, which can be responsive to the request ofblock 1114. For example, the application server 112 can serve thereflexive questionnaire to a client, such as the workstation 118 or theadministrator terminal 120 or the client computing device 124 or others.For example, the application server 112 can request or command thedatabase server 114 to save the reflexive questionnaire as recreatedinto a single record or a plurality of records. For example, theapplication server 112 can request or command an input device togenerate an input or an output device to generate an output based on orinclusive of the reflexive questionnaire as recreated. For example, theinput device can include a receiver, a transceiver, a network interfacecard, a memory card, a cursor or keyboard device, a camera, amicrophone, or others. For example, the output device can include atransmitter, a transceiver, a network interface card, a memory card, acursor or keyboard device, a display, a speaker, or others.

In block 1126, the reflexive questionnaire as recreated can bedisplayed, which can be responsive to the request of block 1114. Forexample, the application server 112 can serve the reflexivequestionnaire as recreated for presenting to a client, such as theworkstation 118 or the administrator terminal 120 or the clientcomputing device 124 or others.

In block 1128, the reflexive questionnaire as recreated can be writtento a data structure, such as a database record, a file, a document, atable, an array, or others. Such writing can be responsive to therequest of block 1114. For example, the application server 112 can servethe reflexive questionnaire as recreated to the database server 114 forwriting the reflexive questionnaire as recreated into a database record.

FIG. 12 shows a flowchart of an embodiment of a process of querying adata source during a presentation of a reflexive questionnaire with aset of questions generated based on a logic contained with a spreadsheetaccording to the present disclosure. In particular, a process 1200 canbe performed via the topology 100 of FIG. 1 , in whole or in part.

In block 1202, a format logic, a semantic logic, and a deduplicationlogic are created for a data source. For example, the application server112 can present a user interface to a client, such as the workstation118 or the administrator terminal 120 or others, where the userinterface is configured to receive the format logic, the semantic logic,and the deduplication logic from the client, such as in a text format,such as in a Boolean format or others. For example, at least one of theformat logic, the semantic logic, or the deduplication logic isconfigured for text processing. For example, the data source can includea single database or a plurality of databases, whether identical to ordifferent from each other schemas. For example, the data source can beremote from the application server 112, but can be local as well.

The format logic enables a format translation or conversion of a set ofdata from a first format to a second format, where the set of data caninclude a set of text data, a set of image data, a set of sound data, orothers. For example, the format logic enables a translation orconversion of a first alphanumeric string or acronym into a secondalphanumeric string or acronym. For example, the format can be fromshortening/abbreviating or lengthening/de-abbreviating or vice versa.For example, using the format logic, an alphanumeric string “APAP” or“Actmnpn” can be format translated or converted into an alphanumericstring “acetaminophen” or “AC” or others.

The semantic logic enables a semantic translation or conversion of afirst semantic meaning of set of data set into a second semantic meaningof the set of data. For example, the semantic logic enables a semanticunderstanding of a plurality of alphanumeric strings in the set of data.For example, using the semantic logic, a plurality of alphanumericstrings “acetaminophen,” “panadol,” and “tylenol” can be semanticallytranslated or converted to refer to a drug with a same active component.

The deduplication logic enables a removal of duplicates from the set ofdata. For example, the removal of duplicates can include deletion,marking or flagging as inactive or not-for-use, or others. For example,the set of data can contain the duplicates that can include a pluralityof data items of same data type and same content. For example, using thededuplication logic, a plurality of alphanumeric strings “acetaminophen”can be analyzed and duplicates can be removed resulting in a single“acetaminophen” data item remaining in the set of data.

In block 1204, the format logic, the semantic logic, and thededuplication logic are saved, such via storing, recording, writing, orothers, into a data structure. For example, the application server 112can receive the format logic, the semantic logic, and the deduplicationlogic from the client, such as the workstation 118 or the administratorterminal 120 or others. Note that the data structure can be a singledata structure, such as a file, a database record, a table, or others.Also, note that the data structure can be a plurality of datastructures, where the format logic, the semantic logic, and thededuplication logic can be stored in a distributed manner in anycorrespondence, such as one-to-one, one-to-many, many-to-one, ormany-to-many. For example, the data structures can include a first datastructure, a second data structure, and a third data structure, wherethe first data structures the format logic, the second data structurestores the semantic logic, and the third data structure stores thededuplication logic. Note that the data structure can be identical to ordifferent from each other in terms of structure or content.

In block 1206, a spreadsheet is populated with a set of rules. Thespreadsheet is as described above. The spreadsheet is populated asdescribed above. The set of rules is as described above. For example,the set of rules can include a logic, such as a Boolean logic or others.For example, the application server 112 can present a user interface toa client, such as the workstation 118 or the administrator terminal 120or others, where the user interface is configured to receive the set ofrules from the client. For example, the user interface can be presentedas a web page or an app page. For example, the user interface canpresent the spreadsheet. For example, the data source can be assigned anetwork address, such as an IP address, a Media Access Control (MAC)address, a domain name, or others, and the network address can beprogrammed into the set of rules, such as via querying the data sourcebased on the network address conditional to a specific response.Likewise, if querying the data source requires various parameters orcriteria, then those can be programmed into the set of rules as well,inclusive of appropriate format conversions. For example, the set ofrules can contain a logic whether the data source should be queriedbased on various answers to various questions generated by the set ofrules and, if so, then what data source should be queried (if more thanone) and what parameters or criteria should be used.

In block 1208, the set of rules is executed from the spreadsheet asdescribed above.

In block 1210, a reflexive questionnaire is presented, where thereflexive questionnaire includes a set of questions generated based onthe set of rules as described above. For example, the application server112 can present a user interface to a client, such as the clientcomputing device 124, where the user interface contains the reflexivequestionnaire with the set of questions generated based on the set ofrules. For example, the user interface can be presented as a web page oran app page. For example, the format logic, the semantic logic, and thededuplication logic can be created or saved by a first client internalto a network as described above and the spreadsheet is populated by asecond client internal to the network as described above and thereflexive questionnaire is completed by a third client external to thenetwork as described above.

In block 1212, the data source is queried. For example, the applicationserver 112 can generate a query based on the set of rules being executedand send the query to the data source based on the set of rules beingexecuted as the reflexive questionnaire is presented on the userinterface of the client, such as the client computing device 124. Forexample, the application server 112 can be triggered to generate thequery based on the set of rules as the set of rules is being executed.For example, the application server 112 can generate the query based ona specific input or answer or a group of inputs or a group of answers onthe reflexive questionnaire and then the query can be sent as programmedbased on the set of rules, which can include fusing the group of inputsor answers. For example, the application server 112 can generate thequery based on a specific input or answer pulled, in real-time, withoutuser prompting, from the reflexive questionnaire during presentation onthe user interface of the client, such as the client computing device124. Likewise, the application server 112 can push a query to the datasource, in real-time, without user prompting, as the reflexivequestionnaire is presented on the user interface of the client, such asthe client computing device 124.

In block 1214, a set of data is received from the data source. Forexample, the set of data can include a result to the query submitted bythe application server 112 to the data source. For example, the resultcan include text, image, sound, file, document, data structure, stings,a JavaScript Object Notation (JSON) object, or other types ofinformation. For example, when the data source includes a plurality ofdatabases configured according to a plurality of schemas, where theresult includes a plurality of results and the schemas are differentfrom each other, then the results can at least partially overlap eachother in terms of content or not overlap each other in terms of content.

In block 1216, the set of data received from the data source istranslated or converted based on the format logic, the semantic logic,and deduplication logic stored in the data structure. For example, theapplication server 112 can process the set of data based on the formatlogic, the semantic logic, and deduplication logic stored in the datastructure such that the set of data received from the data source istranslated or converted for subsequent processing relative to or for thereflexive questionnaire currently being presented on the user interfaceof the client, such as the client computing device 124.

In block 1218, the reflexive questionnaire is updated based on the setof data as translated or converted based on the format logic, thesemantic logic, and deduplication logic stored in the data structure.For example, the application server 112 can push an update to thereflexive questionnaire, in real-time, without user prompting, as thereflexive questionnaire is presented on the user interface of theclient, such as the client computing device 124. The update can includea new question or a new group of questions or updating an alreadypresented question or an already presented group of questions.

In block 1220, a set of answers to the set of questions is received asdescribed above. For example, the application server 112 receive the setof answers from the client computing device 124. For example, the set ofanswers can include a set of textual data, a set of binary data, a setof image data, a set of sound data, or others. For example, the set ofanswers can be based on the reflexive questionnaire as updated.

In block 1222, the set of answers is recorded into a record of adatabase. For example, when the record includes a set of fields, thenthe set of answers can be stored in the set of fields. For example, therecord can be hosted via the database server 114.

In block 1224, the set of answers, as accessed via the record, isevaluated against a threshold. For example, the threshold can include aset of data and the set of answers can be evaluated against the set ofdata. The set of data can include text, image, sound, or other content.For example, the application server 112 can request retrieval of the setof answers via the database server 114 and evaluate the set of answersagainst the set of data. For example, such evaluation can result in ayes or no answer, true or false answer, a needs further review answer,or other answers.

In block 1226, an action is taken based on the set of answers satisfyingor not satisfying a threshold. For example, the application server 112can serve the reflexive questionnaire to a client, such as theworkstation 118 or the administrator terminal 120 or the clientcomputing device 124 or others. For example, the application server 112can request or command an input device to generate an input or an outputdevice to generate an output based on or inclusive of the reflexivequestionnaire. For example, the input device can include a receiver, atransceiver, a network interface card, a memory card, a cursor orkeyboard device, a camera, a microphone, or others. For example, theoutput device can include a transmitter, a transceiver, a networkinterface card, a memory card, a cursor or keyboard device, a display, aspeaker, or others.

In block 1228, the record storing the set of answers is marked based onthe set of answers satisfying the threshold. For example, such markingcan include the application server 112 causing flagging of the record asactive or yes or others. For example, the record can be marked bycontent, such as via the application server 112 causing a modificationof a content the record, or the record can be marked by via theapplication server 112 causing a movement or copying the record intoanother logical entity within the database server 114, such as anothertable or others.

In block 1230, the record storing the set of answers is marked based onthe set of answers not satisfying the threshold. For example, suchmarking can include the application server 112 causing flagging of therecord as inactive or no or others. For example, the record can bemarked by content, such as via the application server 112 causing amodification of a content the record, or the record can be marked by viathe application server 112 causing a movement or copying the record intoanother logical entity within the database server 114, such as anothertable or others.

In block 1232, an action recommendation can be presented to a client,such as the workstation 118 or the administrator terminal 120 or theclient computing device 124 or others. For example, the applicationserver 112 can present the action recommendation based on the set ofanswers satisfying or not satisfying the threshold. For example, theapplication server 112 can generate the action recommendation based onanalyzing the set of answers against a recommendation engine orapplication or logic hosted via or accessible to the application server112. For example, the action recommendation can include text, image,sound, hyperlink, social media post, or others. For example, the actionrecommendation can include a content, which can be user interactive,indicative of why the threshold was or was not satisfied or what can bedone to satisfy or not satisfy the threshold or others.

In block 1234, a status message can be sent to a client, such as theworkstation 118 or the administrator terminal 120 or the clientcomputing device 124 or others. For example, the application server 112can generate the status message based on the set of answers satisfyingor not satisfying the threshold. For example, the application server 112can generate the status message based on analyzing the set of answersagainst a status engine or application or logic hosted via or accessibleto the application server 112. For example, the status message caninclude text, image, sound, hyperlink, social media post, or others. Forexample, the status message can include a content, which can be userinteractive, indicative of prior status, current status, future status,timeline, timeline position, or others.

FIG. 13 shows a flowchart of an embodiment of a process of modularizinglogic statements in a spreadsheet according to the present disclosure.In particular, a process 1300 can be performed via the topology 100 ofFIG. 1 , in whole or in part.

In block 1302, a first spreadsheet is populated with a first set oflogic received from a first client as described above. The firstspreadsheet is as described above. The first set of logic is asdescribed above. For example, the first set of logic can include alogic, such as a Boolean logic or others. For example, the first set oflogic can operate as a callable function, subroutine, object, module, orothers. For example, the first set of logic can generate a set ofquestions specific to a topic, such as a set of demographic information,a set of personal contact information, or others. The first set of logicis received as described above. The first client is as described above.For example, the application server 112 can present the spreadsheet tothe first client, such as the workstation 118 or the administratorterminal 120 or others.

In block 1304, a name is assigned to the first spreadsheet as describedabove. For example, the name can include an alphanumeric string, asound, an image, a barcode, or others. For example, the name can includea pointer, a reference, an identifier, or others. For example, the namecan be manually or automatically generated, such as including a date ortime stamp, a default name, or others. For example, the first client caninput the name or select the name from a list of possible or potentialnames, such as via an autosuggest function in order to avoid namingconflicts. For example, the application server 112 can automaticallyassign the name upon creation of the first spreadsheet, with the namepotentially being subsequently modifiable via the first client.

In block 1306, the first spreadsheet is saved with the first set oflogic via the first client requesting this save or via auto-save. Thefirst spreadsheet is saved with the name. For example, the applicationserver 112 can save the first spreadsheet with the first set of logicvia the first client requesting the application server 112 to save thefirst spreadsheet with the first set of logic or via the applicationserver 112 periodically auto-saving the first spreadsheet, such as every1, 2, 3, 4, 5, 6, 7, 8, 9, 10 or more seconds or minutes or hours orothers.

In block 1308, the name is shared with a second client. For example, theapplication server 112 can share the name with the second client, suchas the workstation 118 or the administrator terminal 120 or others. Forexample, the name can be shared via at least one of a file, acommunication message, a physical medium, or a logic configured to atleast one of grant or deny an access to the name. For example, the filecan include a data file, such as a PDF file, a text file, an MS Officefile, an image file, a sound file, or others. For example, the MS officefile can include a document file, a spreadsheet file, a presentationfile, or others. For example, the file can include an executable file,an archive file, a dynamic-link-library (DLL) file, a settings file, orothers. For example, the communication message can include an email, ashort message service (SMS) message, a text message, an over-the-top(OTT) message, a social media service message, a chat message, aninteractive voice response (IVR) phone call message, or others. Forexample, the physical medium can include a physical document, which caninclude paper, plastic, metal, wood, rubber, or others. For example, thephysical document can include a letter, a printout, a catalog, a flyer,a newspaper, a magazine, a book, a pamphlet, a binder, or others. Forexample, the physical medium can include a memory, whether mechanical,electrical, or others. For example, the physical medium can include aflash drive or others. For example, the logic configured to at least oneof grant or deny an access to the name can include a hardwarearrangement or component thereof, such as a password or biometric-basedcontainer or others, a software arrangement or component thereof, suchas a module, an object, a function, or others, or others. For example,the logic configured to at least one of grant or deny an access to thename based on the second client or user thereof being allowed orforbidden to access the name based on various parameters or criteria.

In block 1310, a second spreadsheet is populated with a second set oflogic inclusive of the name sourced from the second client. The secondspreadsheet is as described above. The second spreadsheet is populatedas described above. The second set of logic is as described above. Forexample, the second set of logic can include a logic, such as a Booleanlogic or others.

Where programmatically desired in point of execution, such as at adesired reflexive questioning section or others, the second set of logiccan be created, modified, edited, or input to include, call, point, orrefer to the name corresponding to the first spreadsheet. For example,the name can be autocompleted based on a set of names corresponding to aset of spreadsheets stored in a predefined file directory or folder ordata source, which can be changed to another file directory or folder ordata source. As such, if the second set of logic is executed and thisexecution reaches the name in the second set of logic, then a presenceof the name can enable the second spreadsheet to locate the firstspreadsheet and open the first spreadsheet for appropriate access. Then,the first spreadsheet can be read or imported into the secondspreadsheet or the first set of logic can be copied from the firstspreadsheet to the second spreadsheet to logically replace or append orassociate with the name. Then, the first set of logic is executed whenpoint of execution reaches the name and the first spreadsheet can beclosed. This technique can enable the presence of the name to functionas a trigger or flag, at a relevant point of execution, for anincorporation by reference via the name, where the incorporation byreference enables execution of the first set of logic from the firstspreadsheet in the second set of logic in the second spreadsheet. Forexample, the name can function as a virtual logic statement for thefirst set of logic. The incorporation can be at programming time,compilation time, execution time, or others. For example, the secondspreadsheet can be configured to display the first set of logic afterthe second spreadsheet is populated with the name, which can replace thename or follow the name. This feature can be a default feature.Likewise, the second spreadsheet cane configured to hide the first setof logic responsive to a hide request from the second client, with thehide request being activated via a menu or setting of the spreadsheet.For example, the second spreadsheet can be configured to hide the firstset of logic after the second spreadsheet is populated with the name,which enables programming simplicity. This feature can be a defaultfeature. Likewise, the second spreadsheet can be configured to show thefirst set of logic responsive to a show request from the second client,with the show request being activated via a menu or setting of thespreadsheet. Note that the show request and the hide request cancorrespond to two corresponding different icons in the menu or a singleicon in the menu that enables binary action upon activation ordeactivation.

In block 1312, the second spreadsheet is saved with the second set oflogic. For example, the application server 112 can store the firstspreadsheet and the second spreadsheet remote from each other or localto each other, where the second spreadsheet contains the second set oflogic with the name of the first spreadsheet. Note that the first set oflogic has less, equal, more logic statements than the second set oflogic.

In block 1314, a user interface is presented to a third client. The userinterface contains a reflexive questionnaire containing a set ofquestions generated based on the second set of logic inclusive of thename when the second set of logic is executed. For example, theapplication server 112 can execute the second set of logic from thesecond spreadsheet such that the first set of logic is called based onthe name and executed based on the name during the execution of thesecond set of logic. The user interface can be presented on a web pageserved to the third client, such as the client computing device 124 orothers. The reflexive questionnaire is as described above. The web pageis presented in a client browser as described above. The set ofquestions is as described above.

In block 1316, a set of answers to the set of questions is received fromthe third client as described above. For example, the application server112 can store the set of answers in a database record, such as via thedatabase server 114. For example, the set of answers can include a setof textual data, a set of binary data, a set of image data, a set ofsound data, or others. For example, when the database record includes aset of fields, then the answers can be stored in the set of fields.

In block 1318, the set of answers is evaluated against a threshold. Notethat the threshold can be a single threshold or a plurality ofthresholds. For example, the threshold can include a set of data and theset of answers can be evaluated against the set of data. The set of datacan include text, image, sound, or other content. For example, theapplication server 112 can request retrieval of the set of answers viathe database server 114 and evaluate the set of answers against the setof data. For example, such evaluation can result in a yes or no answer,true or false answer, a needs further review answer, or other answers.

In block 1320, a first action is taken based on the set of answerssatisfying the threshold and a second action is taken based on the setof answers not satisfying the threshold. For example, the applicationserver 112 can mark the database record as satisfying the threshold ornot satisfying the threshold based on the set of answers satisfying thethreshold or not satisfying the threshold respectively. For example, theapplication server 112 can serve the reflexive questionnaire to aclient, such as the workstation 118 or the administrator terminal 120 orthe client computing device 124 or others. For example, the applicationserver 112 can request or command an input device to generate an inputor an output device to generate an output based on or inclusive of thereflexive questionnaire. For example, the input device can include areceiver, a transceiver, a network interface card, a memory card, acursor or keyboard device, a camera, a microphone, or others. Forexample, the output device can include a transmitter, a transceiver, anetwork interface card, a memory card, a cursor or keyboard device, adisplay, a speaker, or others.

In block 1322, the record is marked as satisfying the threshold asexplained above. For example, such marking can include the applicationserver 112 causing flagging of the database record as active or yes orothers. For example, the record can be marked by content, such as viathe application server 112 causing a modification of a content therecord, or the record can be marked by via the application server 112causing a movement or copying the record into another logical entitywithin the database server 114, such as another table or others.

In block 1324, the record is marked as not satisfying the threshold asexplained above. For example, such marking can include the applicationserver 112 causing flagging of the record as inactive or no or others.For example, the record can be marked by content, such as via theapplication server 112 causing a modification of a content the record,or the record can be marked by via the application server 112 causing amovement or copying the record into another logical entity within thedatabase server 114, such as another table or others.

In block 1326, an action recommendation is presented to a client asdescribed above. The client can be the workstation 118 or theadministrator terminal 120 or the client computing device 124 or others.For example, the application server 112 can present the actionrecommendation based on the set of answers satisfying or not satisfyingthe thresholds. For example, the application server 112 can generate theaction recommendation based on analyzing the set of answers against arecommendation engine or application or logic hosted via or accessibleto the application server 112. For example, the action recommendationcan include text, image, sound, hyperlink, social media post, or others.For example, the action recommendation can include a content, which canbe user interactive, indicative of why the threshold was or was notsatisfied or what can be done to satisfy or not satisfy the threshold orothers.

In block 1328, a status message is sent to a client as described above.The client can be the workstation 118 or the administrator terminal 120or the client computing device 124 or others. For example, theapplication server 112 can generate the status message based on the setof answers satisfying or not satisfying the threshold. For example, theapplication server 112 can generate the status message based onanalyzing the set of answers against a status engine or application orlogic hosted via or accessible to the application server 112. Forexample, the status message can include text, image, sound, hyperlink,social media post, or others. For example, the status messages caninclude a content, which can be user interactive, indicative of priorstatus, current status, future status, timeline, timeline position, orothers.

FIG. 14 shows a flowchart of an embodiment of a method for presenting aplurality of reflexive questionnaires on a plurality of web pages havinga plurality of domain names assigned thereto according to thisdisclosure. In particular, a process 1400 can be performed via thetopology 100 of FIG. 1 , in whole or in part.

In block 1402, a spreadsheet is open for modification as describedabove. The spreadsheet is as described above.

In block 1404, the spreadsheet is populated with a plurality of rulesfor a plurality of web pages associated with a plurality of domain namesassigned thereto. The spreadsheet is populated as described above. Therules are as described above. For example, the rules can include alogic, such as a Boolean logic or others. For example, the applicationserver 112 can present a user interface to a client, such as theworkstation 118 or the administrator terminal 120 or others, where theuser interface is configured to receive the rules from the client. Forexample, the user interface can be presented as a web page or an apppage. For example, the user interface can present the spreadsheet.

The rules can correspond to the domain names in various ways, such as aone-to-one correspondence, one-to-many correspondence, many-to-onecorrespondence, or many-to-many correspondence. For example, at leastone of the domain names can include an alphabetic or alphanumeric stringinclusive of grammar signs, such as dashes, commas, or others. Forexample, the rules can be grouped based on the domain names, such asbased on clients accessing the web pages associated with the domainnames. For example, a first set of rules can apply to a first clientaccessing a first web page associated with a first domain name and asecond set of rules can apply to a second client accessing a second webpage associated with a second domain name. Likewise, some rules can beshared between the first web page associated with the first domain nameand the second web page associated with the second domain name, i.e.,some rules may apply to the first client accessing the first web pageassociated with the first domain name and to the second client accessingthe second web page associated with the second domain name. For example,the rules can be programmed to determine which domain name was used toaccess a web page containing a reflexive questionnaire with a set ofquestions generated based on the set of rules. For example, suchdetermination can be in real-time and without user prompting. Forexample, the domain names name can include www.xyz.com or www.abc.de.netor a network address, such as an IP address, a Media Access Control(MAC) address, or others, and the domain names can be programmed intothe rules, such as via presenting certain questions based on certainclients accessing certain web pages associated with certain domainnames. Note that at least one of the domain names (hostname) may be usedto identify an IP address based on a translation by a Domain Name System(DNS) server or a hosts tile from an alphabetic (lower or upper case) oralphanumeric string into an IP address, whether the DNS server or thehost file is local to or remote from the spreadsheet. Also, note that atleast one of the domain names can include a top level domain (TLD),whether generic or country code. Moreover, note that at least one of thedomain names can include a second-level or third-level or n-level domainnames and can be concatenated and delimited by dots. Additionally, notethat prefixes, such as ftp or www or mail can involve a particularservice. For example, the application server 112 can present thespreadsheet to a client, such as the workstation 118 or theadministrator terminal 120 or others, where the spreadsheet isconfigured to receive a plurality of logic rules for a plurality of webpages associated with a plurality of domain names, where the domainnames are different from each other. For example, the logic rules can bea single set of logic rules for the domain names. For example, the logicrules can include a first group of logic rules and a second group oflogic rules, where the web pages include a first web page and a secondweb page, where the domain names include a first domain name associatedwith the first web page and a second domain name associated with thesecond web page, where the first group of logic rules applies to thefirst domain name and the second group of logic rules application to thesecond domain name. Moreover, the logic rules can include a third groupof logic rules that applies or avoids applying to the first domain nameand the second domain name. Additionally, at least one of the web pagescan be a landing page for at least one of the domain names when thatdomain name is entered into the browser of the client.

In block 1406, the spreadsheet as modified is saved as described above.

In block 1408, the rules from the spreadsheet are executed as describedabove. For example, the application server 112 receives the logic rulesfrom the client, populates the spreadsheet with the logic rules, andexecutes the logic rules from the spreadsheet.

In block 1410, a plurality of reflexive questionnaires are presented onthe web pages associated with the domain names. The reflexivequestionnaires are described above. The web pages are presented inclient browsers. The reflexive questionnaires may present identical ornon-identical question content or formatting based on the domain names.For example, a reflexive questionnaire A with question content A ispresented on web page A associated with domain name A (www.ab.com),whereas a reflexive questionnaire B with question content B is presentedon web page B associated with domain name B (www.cd.ef.org), with thedomain name A and the domain name B being different from each other,whether IP addresses as translated are different or identical. However,note that the reflexive questionnaire A presented on web page Aassociated with domain name A may share or avoid sharing some questionswith reflexive questionnaire B presented on web page B associated withdomain name B. For example, the application server 112 presents aplurality of reflexive questionnaires on the web pages associated withthe domain names as the web pages are accessed by a plurality ofbrowsers, where the reflexive questionnaires include a plurality ofquestions generated based on the logic rules.

In block 1412, a plurality of answers to the questions are received fromthe reflexive questionnaires as explained above. For example, theapplication server 112 receive the set of answers from the clientcomputing device 124. For example, the set of answers can include a setof textual data, a set of binary data, a set of image data, a set ofsound data, or others.

In block 1414, the answers are recorded into a plurality of records of adatabase as explained above. For example, the answers can be stored inthe records. For example, when the records includes a set of fields,then the answers can be stored in the set of fields. For example, therecords can be hosted via the database server 114.

In block 1416, the answers from the records are evaluated against aplurality of thresholds as explained above. Note that the thresholds canbe a single threshold but manifested as copies thereof or there can bemany different thresholds. For example, at least one of the thresholdscan include a set of data and the set of answers can be evaluatedagainst the set of data. The set of data can include text, image, sound,or other content. For example, the application server 112 can requestretrieval of the answers via the database server 114 and evaluate theanswers against the set of data. For example, such evaluation can resultin a yes or no answer, true or false answer, a needs further reviewanswer, or other answers.

In block 1418, a plurality of actions are taken based on the answerssatisfying or not satisfying the thresholds as explained above. Forexample, the application server 112 can mark the database records assatisfying the threshold or not satisfying the threshold based on theanswers satisfying the threshold or not satisfying the thresholdrespectively. For example, the application server 112 can serve thereflexive questionnaire to a client, such as the workstation 118 or theadministrator terminal 120 or the client computing device 124 or others.For example, the application server 112 can request or command an inputdevice to generate an input or an output device to generate an outputbased on or inclusive of the reflexive questionnaire. For example, theinput device can include a receiver, a transceiver, a network interfacecard, a memory card, a cursor or keyboard device, a camera, amicrophone, or others. For example, the output device can include atransmitter, a transceiver, a network interface card, a memory card, acursor or keyboard device, a display, a speaker, or others. As such, adeveloper can code different front ends, such as havenlife.com andmassmutual.com. For example, the developer can program to call a firstset of rules for havenlife.com and a second set of rules formassmutual.com, thereby effectively reducing a need to create rules eachtime, although some, none, or all rule overlap or rule uniqueness ispossible in any manner.

In block 1420, the records that satisfy the thresholds are markedaccordingly as explained above. For example, such marking can includethe application server 112 causing flagging of the records as active oryes or others. For example, the records can be marked by content, suchas via the application server 112 causing a modification of a contentthe records, or the records can be marked by via the application server112 causing a movement or copying the records into another logicalentity within the database server 114, such as another table or others

In block 1422, the records that do not satisfy the thresholds are markedaccordingly as explained above. For example, such marking can includethe application server 112 causing flagging of the records as inactiveor no or others. For example, the records can be marked by content, suchas via the application server 112 causing a modification of a contentthe records, or the record can be marked by via the application server112 causing a movement or copying the records into another logicalentity within the database server 114, such as another table or others.

In block 1424, a plurality of action recommendations are presented to aclient as explained above. The client can be the workstation 118 or theadministrator terminal 120 or the client computing device 124 or others.For example, the application server 112 can present the actionrecommendations based on the answers satisfying or not satisfying thethresholds. For example, the application server 112 can generate theaction recommendations based on analyzing the answers against arecommendation engine or application or logic hosted via or accessibleto the application server 112. For example, the action recommendationscan include text, image, sound, hyperlink, social media post, or others.For example, the action recommendations can include a content, which canbe user interactive, indicative of why the thresholds was or was notsatisfied or what can be done to satisfy or not satisfy the thresholdsor others. For example, the application server 112 can present an actionrecommendation to at least one of the browsers based on a subset of theanswers not satisfying the threshold, where the subset is associatedwith the at least one of the browsers.

In block 1426, a plurality of status messages are sent to a client asexplained above. The client can be the workstation 118 or theadministrator terminal 120 or the client computing device 124 or others.For example, the application server 112 can generate the status messagesbased on the answers satisfying or not satisfying the thresholds. Forexample, the application server 112 can generate the status messagesbased on analyzing the answers against a status engine or application orlogic hosted via or accessible to the application server 112. Forexample, the status messages can include text, image, sound, hyperlink,social media post, or others. For example, the status messages caninclude a content, which can be user interactive, indicative of priorstatus, current status, future status, timeline, timeline position, orothers. For example, the application server 112 can send a statusmessage to at least one of the browsers based on a subset of the answerssatisfying the threshold, where the subset is associated with the atleast one of the browsers.

In some embodiments, a server can be programmed to perform a method. Themethod can include presenting, by a server, a first user interface to afirst client device, wherein the first user interface is configured toreceive a set of logic and a version identifier from the first clientdevice; populating, by the server, a spreadsheet with the set of logicand the version identifier; executing, by the server, the set of logicfrom the spreadsheet; presenting, by the server, a second user interfaceto a second client device, wherein the second user interface contains areflexive questionnaire with a set of questions generated based on theset of logic; storing, by the server, the set of questions such that theset of questions is associated with the version identifier; receiving,by the server, a set of answers to the set of questions inputted fromthe second client device; storing, by the server, the set of answers asa set of metadata; associating, by the server, the version identifierwith the set of metadata; presenting, by the server, a third userinterface to a third client device, wherein the third user interface isconfigured to receive a request from the third client device; locating,by the server, the version identifier responsive to the request from thethird client device; retrieving, by the server, the set of questionsbased on the version identifier; retrieving, by the server, the set ofmetadata based on the version identifier; generating, by the server, thereflexive questionnaire with the set of questions based on the versionidentifier and the set of answers based on the set of metadataresponsive to the request; and presenting, by the server, the reflexivequestionnaire on the third user interface to the third client deviceresponsive to the request. The version identifier can relate to a datethe spreadsheet is populated with the set of logic. The versionidentifier can include at least one of an alphanumeric, a barcode, animage, or a sound. The version identifier can be stored as the set ofmetadata. The set of metadata can be stored in a single data structure.The set of metadata can be stored in a plurality of data structures. Therequest can relate to the version identifier. The set of metadata can bea first set of metadata, where the set of answers can be a first set ofanswers, where the version identifier can be associated with a secondset of metadata, where the second set of metadata can be associated withthe second set of answers to the set of questions. The first client andthe third client can be internal to a network containing the server,where the second client can be external to the network. The set ofmetadata can be hierarchical.

In some embodiments, a server can be programmed to perform a method. Themethod can include presenting, by a server, a first user interface to afirst client device, wherein the first user interface is configured toreceive a format logic, a semantic logic, and a deduplication logic fromthe client; receiving, by the server, the format logic, the semanticlogic, and the deduplication logic from the first client device;storing, by the server, the format logic, the semantic logic, and thededuplication logic in a data structure; presenting, by the server, asecond user interface to a second client device, wherein the second userinterface is configured to receive a set of rules from the second clientdevice; receiving, by the server, the set of rules from the secondclient device; populating, by the server, a spreadsheet with the set ofrules; executing, by the server, the set of rules from the spreadsheet;presenting, by the server, a third user interface to a third clientdevice, wherein the third user interface includes a reflexivequestionnaire including a set of questions generated based on the set ofrules; sending, by the server, a query to a data source as the reflexivequestionnaire is presented on the third user interface, wherein thequery is triggered based on the set of rules, wherein the data source isremote from the server; receiving, by the server, a result to the queryfrom the data source; translating, by the server, the result based onthe format logic, the semantic logic, and the deduplication logic fromthe data structure; updating, by the server, the reflexive questionnairebased on the result as translated; and marking, by the server, thedatabase record as satisfying the threshold based on a set of answers tothe questions from the third client device based on the reflexivequestionnaire as updated satisfying the threshold, otherwise, marking,by the server, the database record as not satisfying the threshold basedon the set of answers not satisfying the threshold. The data structurecan be a single data structure. The data structure can be a plurality ofdata structures. The data structures can a first data structure, asecond data structure, and a third data structure, where the first datacan structure the format logic, where the second data structure canstore the semantic logic, where the third data structure can store thededuplication logic. The first client and the second client can beinternal to a network containing the server, where the third client isexternal to the network. The data source can include a plurality ofdatabases configured according to a plurality of schemas, where theresult includes a plurality of results, where the schemas are differentfrom each other, where the results at least partially overlap eachother. The data source can include a plurality of databases configuredaccording to a plurality of schemas, where the result includes aplurality of results, where the schemas are different from each other,where the results do not overlap each other. The method can furthercomprise: presenting, by the server, an action recommendation to thethird client based on the set of answers not satisfying the threshold.The method can further comprise: sending, by the server, a statusmessage to the third client based on the set of answers satisfying thethreshold. At least one of the format logic, the semantic logic, or thededuplication logic can be configured for text processing.

In some embodiments, a server can be programmed to perform a method. Themethod can include presenting, by a server, a first spreadsheet to afirst client device; populating, by the server, the first spreadsheetwith a first set of logic received from the first client device;assigning, by the server, a name to the first spreadsheet containing thefirst set of logic; enabling, by the server, the name to be shared witha second client device; populating, by the server, a second spreadsheetwith a second set of logic received from the second client device,wherein the second set of logic contains the name; executing, by theserver, the second set of logic from the second spreadsheet such thatthe first set of logic is called based on the name and executed based onthe name; presenting, by the server, a user interface to a third clientdevice, wherein the user interface contains a reflexive questionnaireincluding a set of questions generated based on the second set of logicinclusive of calling the first set of logic; and marking, by the server,the database record as satisfying the threshold or not satisfying thethreshold based on a set of answers to the set of questions from thethird client device. The first spreadsheet and the second spreadsheetcan be stored remote from each other. The first spreadsheet and thesecond spreadsheet can be stored local to each other. The secondspreadsheet can be configured to display the first set of logic afterthe second spreadsheet is populated with the name. The secondspreadsheet can be configured to hide the first set of logic responsiveto a hide request from the second client. The second spreadsheet can beconfigured to hide the first set of logic after the second spreadsheetis populated with the name. The second spreadsheet can be configured toshow the first set of logic responsive to a show request from the secondclient. The name can be shared via at least one of a file, acommunication message, a physical medium, or a logic configured to atleast one of grant or deny an access to the name. The first set of logiccan have less logic statements than the second set of logic. The firstset of logic can have more logic statements than the second set oflogic.

In some embodiments, a server can be programmed to perform a method. Themethod can include presenting, by a server, a spreadsheet to a clientdevice, wherein the spreadsheet is configured to receive a plurality oflogic rules for a plurality of web pages associated with a plurality ofdomain names, wherein the domain names are different from each other;receiving, by the server, the logic rules from the client device;populating, by the server, the spreadsheet with the logic rules;executing, by the server, the logic rules from the spreadsheet;presenting, by the server, a plurality of reflexive questionnaires onthe web pages associated with the domain names as the web pages areaccessed by a plurality of browsers, wherein the reflexivequestionnaires include a plurality of questions generated based on thelogic rules; and marking, by the server, the database records assatisfying the threshold or not satisfying a threshold based on answersinputted in the browsers. The logic rules can be a single set of logicrules for the domain names. The logic rules can include a first group oflogic rules and a second group of logic rules, where the web pagesinclude a first web page and a second web page, where the domain namesinclude a first domain name associated with the first web page and asecond domain name associated with the second web page, where the firstgroup of logic rules applies to the first domain name and the secondgroup of logic rules application to the second domain name. The logicrules can include a third group of logic rules that applies to the firstdomain name and the second domain name. At least one of the domain namescan include an alphabetic string. The method can further comprise:presenting, by the server, an action recommendation to at least one ofthe browsers based on a subset of the set of answers not satisfying thethreshold, where the subset can be associated with the at least one ofthe browsers. The method can further comprise: sending, by the server, astatus message to at least one of the browsers based on a subset of theset of answers satisfying the threshold, where the subset is associatedwith the at least one of the browsers. The method can further comprise:sending, by the server, a plurality of queries to a data source as thereflexive questionnaires are presented on the browsers, wherein thequeries are triggered based on the set of rules, wherein the data sourceis remote from the server; receiving, by the server, a plurality ofresults to the queries from the data source; configuring, by the server,the results for processing; and updating, by the server, the reflexivequestionnaires based on the result as configured, wherein the answersare based on the reflexive questionnaires as updated. The data sourcecan include a plurality of databases configured according to a pluralityof schemas, where the schemas are different from each other, where theresults at least partially overlap each other. The data source caninclude a plurality of databases configured according to a plurality ofschemas, where the schemas are different from each other, where theresults do not overlap each other.

Various embodiments of the present disclosure may be implemented in adata processing system suitable for storing and/or executing programcode that includes at least one processor, including a multicoreprocessor, coupled directly or indirectly to memory elements through asystem bus. The memory elements include, for instance, local memoryemployed during actual execution of the program code, bulk storage, andcache memory which provide temporary storage of at least some programcode in order to reduce the number of times code must be retrieved frombulk storage during execution.

Input/Output or I/O devices (including, but not limited to, keyboards,displays, pointing devices, DASD, tape, CDs, DVDs, thumb drives andother memory media, etc.) can be coupled to the system either directlyor through intervening I/O controllers. Network adapters may also becoupled to the system to enable the data processing system to becomecoupled to other data processing systems or remote printers or storagedevices through intervening private or public networks. Modems, cablemodems, and Ethernet cards are just a few of the available types ofnetwork adapters.

The present disclosure may be embodied in a system, a method, and/or acomputer program product. The computer program product may include acomputer readable storage medium (or media) having computer readableprogram instructions thereon for causing a processor to carry outaspects of the present disclosure. The computer readable storage mediumcan be a tangible device that can retain and store instructions for useby an instruction execution device. The computer readable storage mediummay be, for example, but is not limited to, an electronic storagedevice, a magnetic storage device, an optical storage device, anelectromagnetic storage device, a semiconductor storage device, or anysuitable combination of the foregoing. A non-exhaustive list of morespecific examples of the computer readable storage medium includes thefollowing: a portable computer diskette, a hard disk, a random accessmemory (RAM), a read-only memory (ROM), an erasable programmableread-only memory (EPROM or Flash memory), a static random access memory(SRAM), a portable compact disc read-only memory (CD-ROM), a digitalversatile disk (DVD), a memory stick, a floppy disk, a mechanicallyencoded device such as punch-cards or raised structures in a groovehaving instructions recorded thereon, and any suitable combination ofthe foregoing.

Computer readable program instructions described herein can bedownloaded to respective computing/processing devices from a computerreadable storage medium or to an external computer or external storagedevice via a network, for example, the Internet, a local area network, awide area network and/or a wireless network. The network may comprisecopper transmission cables, optical transmission fibers, wirelesstransmission, routers, firewalls, switches, gateway computers and/oredge servers. A network adapter card or network interface in eachcomputing/processing device receives computer readable programinstructions from the network and forwards the computer readable programinstructions for storage in a computer readable storage medium withinthe respective computing/processing device.

Computer readable program instructions for carrying out operations ofthe present disclosure may be assembler instructions,instruction-set-architecture (ISA) instructions, machine instructions,machine dependent instructions, microcode, firmware instructions,state-setting data, or either source code or object code written in anycombination of one or more programming languages, including an objectoriented programming language such as Smalltalk, C++ or the like, andconventional procedural programming languages, such as the “C”programming language, “R” programming language or similar programminglanguages. A code segment or machine-executable instructions mayrepresent a procedure, a function, a subprogram, a program, a routine, asubroutine, a module, a software package, a class, or any combination ofinstructions, data structures, or program statements. A code segment maybe coupled to another code segment or a hardware circuit by passingand/or receiving information, data, arguments, parameters, or memorycontents. Information, arguments, parameters, data, etc. may be passed,forwarded, or transmitted via any suitable means including memorysharing, message passing, token passing, network transmission, amongothers. The computer readable program instructions may execute entirelyon the user's computer, partly on the user's computer, as a stand-alonesoftware package, partly on the user's computer and partly on a remotecomputer or entirely on the remote computer or server. In the latterscenario, the remote computer may be connected to the user's computerthrough any type of network, including a local area network (LAN) or awide area network (WAN), or the connection may be made to an externalcomputer (for example, through the Internet using an Internet ServiceProvider). In some embodiments, electronic circuitry including, forexample, programmable logic circuitry, field-programmable gate arrays(FPGA), or programmable logic arrays (PLA) may execute the computerreadable program instructions by utilizing state information of thecomputer readable program instructions to personalize the electroniccircuitry, in order to perform aspects of the present disclosure.

Aspects of the present disclosure are described herein with reference toflowchart illustrations and/or block diagrams of methods, apparatus(systems), and computer program products according to embodiments of thedisclosure. It will be understood that each block of the flowchartillustrations and/or block diagrams, and combinations of blocks in theflowchart illustrations and/or block diagrams, can be implemented bycomputer readable program instructions. The various illustrative logicalblocks, modules, circuits, and algorithm steps described in connectionwith the embodiments disclosed herein may be implemented as electronichardware, computer software, or combinations of both. To clearlyillustrate this interchangeability of hardware and software, variousillustrative components, blocks, modules, circuits, and steps have beendescribed above generally in terms of their functionality. Whether suchfunctionality is implemented as hardware or software depends upon theparticular application and design constraints imposed on the overallsystem. Skilled artisans may implement the described functionality invarying ways for each particular application, but such implementationdecisions should not be interpreted as causing a departure from thescope of the present disclosure.

The flowchart and block diagrams in the Figures illustrate thearchitecture, functionality, and operation of possible implementationsof systems, methods, and computer program products according to variousembodiments of the present disclosure. In this regard, each block in theflowchart or block diagrams may represent a module, segment, or portionof instructions, which comprises one or more executable instructions forimplementing the specified logical function(s). In some alternativeimplementations, the functions noted in the block may occur out of theorder noted in the figures. For example, two blocks shown in successionmay, in fact, be executed substantially concurrently, or the blocks maysometimes be executed in the reverse order, depending upon thefunctionality involved. It will also be noted that each block of theblock diagrams and/or flowchart illustration, and combinations of blocksin the block diagrams and/or flowchart illustration, can be implementedby special purpose hardware-based systems that perform the specifiedfunctions or acts or carry out combinations of special purpose hardwareand computer instructions.

Words such as “then,” “next,” etc. are not intended to limit the orderof the steps; these words are simply used to guide the reader throughthe description of the methods. Although process flow diagrams maydescribe the operations as a sequential process, many of the operationscan be performed in parallel or concurrently. In addition, the order ofthe operations may be re-arranged. A process may correspond to a method,a function, a procedure, a subroutine, a subprogram, etc. When a processcorresponds to a function, its termination may correspond to a return ofthe function to the calling function or the main function.

Although preferred embodiments have been depicted and described indetail herein, it will be apparent to those skilled in the relevant artthat various modifications, additions, substitutions and the like can bemade without departing from the spirit of the disclosure, and these are,therefore, considered to be within the scope of the disclosure, asdefined in the following claims.

Features or functionality described with respect to certain exampleembodiments may be combined and sub-combined in and/or with variousother example embodiments. Also, different aspects and/or elements ofexample embodiments, as disclosed herein, may be combined andsub-combined in a similar manner as well. Further, some exampleembodiments, whether individually and/or collectively, may be componentsof a larger system, wherein other procedures may take precedence overand/or otherwise modify their application. Additionally, a number ofsteps may be required before, after, and/or concurrently with exampleembodiments, as disclosed herein. Note that any and/or all methodsand/or processes, at least as disclosed herein, can be at leastpartially performed via at least one entity or actor in any manner.

The terminology used herein can imply direct or indirect, full orpartial, temporary or permanent, action or inaction. For example, whenan element is referred to as being “on,” “connected” or “coupled” toanother element, then the element can be directly on, connected orcoupled to the other element and/or intervening elements can be present,including indirect and/or direct variants. In contrast, when an elementis referred to as being “directly connected” or “directly coupled” toanother element, there are no intervening elements present.

Although the terms first, second, etc. can be used herein to describevarious elements, components, regions, layers and/or sections, theseelements, components, regions, layers and/or sections should notnecessarily be limited by such terms. These terms are used todistinguish one element, component, region, layer or section fromanother element, component, region, layer or section. Thus, a firstelement, component, region, layer, or section discussed below could betermed a second element, component, region, layer, or section withoutdeparting from the teachings of the present disclosure.

Furthermore, relative terms such as “below,” “lower,” “above,” and“upper” can be used herein to describe one element's relationship toanother element as illustrated in the accompanying drawings. Suchrelative terms are intended to encompass different orientations ofillustrated technologies in addition to the orientation depicted in theaccompanying drawings. For example, if a device in the accompanyingdrawings were turned over, then the elements described as being on the“lower” side of other elements would then be oriented on “upper” sidesof the other elements. Similarly, if the device in one of the figureswere turned over, elements described as “below” or “beneath” otherelements would then be oriented “above” the other elements. Therefore,the example terms “below” and “lower” can encompass both an orientationof above and below.

The terminology used herein is for describing particular exampleembodiments and is not intended to be necessarily limiting of thepresent disclosure. As used herein, the singular forms “a,” “an” and“the” are intended to include the plural forms as well, unless thecontext clearly indicates otherwise. The terms “comprises,” “includes”and/or “comprising,” “including” when used in this specification,specify the presence of stated features, integers, steps, operations,elements, and/or components, but do not preclude the presence and/oraddition of one or more other features, integers, steps, operations,elements, components, and/or groups thereof.

As used herein, the term “or” is intended to mean an inclusive “or”rather than an exclusive “or.” That is, unless specified otherwise, orclear from context, “X employs A or B” is intended to mean any of thenatural inclusive permutations. That is, if X employs A; X employs B; orX employs both A and B, then “X employs A or B” is satisfied under anyof the foregoing instances.

Unless otherwise defined, all terms (including technical and scientificterms) used herein have the same meaning as commonly understood by oneof ordinary skill in the art to which this disclosure belongs. Theterms, such as those defined in commonly used dictionaries, should beinterpreted as having a meaning that is consistent with their meaning inthe context of the relevant art and should not be interpreted in anidealized and/or overly formal sense unless expressly so defined herein.

As used herein, the term “about” and/or “substantially” refers to a+/−10% variation from the nominal value/term. Such variation is alwaysincluded in any given.

If any disclosures are incorporated herein by reference and suchdisclosures conflict in part and/or in whole with the presentdisclosure, then to the extent of conflict, and/or broader disclosure,and/or broader definition of terms, the present disclosure controls. Ifsuch disclosures conflict in part and/or in whole with one another, thento the extent of conflict, the later-dated disclosure controls.

What is claimed is:
 1. A method comprising: presenting, by a server, afirst user interface to a first client device, wherein the first userinterface is configured to receive a format logic, a semantic logic, anda deduplication logic from a client; receiving, by the server, theformat logic, the semantic logic, and the deduplication logic from thefirst client device; storing, by the server, the format logic, thesemantic logic, and the deduplication logic in a data structure;presenting, by the server, a second user interface to a second clientdevice, wherein the second user interface is configured to receive a setof rules from the second client device; receiving, by the server, theset of rules from the second client device; populating, by the server, aspreadsheet with the set of rules; executing, by the server, the set ofrules from the spreadsheet; presenting, by the server, a third userinterface to a third client device, wherein the third user interfaceincludes a reflexive questionnaire including a set of questionsgenerated based on the set of rules; receiving, by the server from thethird client device, one or more answers to the set of questions of thereflexive questionnaire, the one or more answers input by a user;sending, by the server, a query to a data source as the reflexivequestionnaire is presented on the third user interface, wherein thequery comprises the one or more answers and is triggered based on theset of rules, wherein the data source is remote from the server;receiving, by the server, a result to the query from the data source;translating, by the server, the result based on the format logic, thesemantic logic, and the deduplication logic from the data structure; andupdating, by the server, the reflexive questionnaire based on the resultas translated.
 2. The method of claim 1, wherein the data structure is asingle data structure.
 3. The method of claim 1, wherein the firstclient and the second client are internal to a network containing theserver, wherein the third client is external to the network.
 4. Themethod of claim 1, wherein the data source includes a plurality ofdatabases configured according to a plurality of schemas, wherein theresult includes a plurality of results, wherein the schemas aredifferent from each other, wherein the results at least partiallyoverlap each other.
 5. The method of claim 1, wherein the data sourceincludes a plurality of databases configured according to a plurality ofschemas, wherein the result includes a plurality of results, wherein theschemas are different from each other, wherein the results do notoverlap each other.
 6. The method of claim 1, further comprising:presenting, by the server, an action recommendation to the third clientbased on a set of answers not satisfying the threshold.
 7. The method ofclaim 1, further comprising: sending, by the server, a status message tothe third client based on a set of answers satisfying the threshold. 8.The method of claim 1, wherein at least one of the format logic, thesemantic logic, or the deduplication logic is configured for textprocessing.
 9. The method of claim 1, wherein the data structure is aplurality of data structures.
 10. The method of claim 9, wherein thedata structures includes a first data structure, a second datastructure, and a third data structure, wherein the first data structuresthe format logic, wherein the second data structure stores the semanticlogic, wherein the third data structure stores the deduplication logic.11. A system comprising: a server configured to: present a first userinterface to a first client device, wherein the first user interface isconfigured to receive a format logic, a semantic logic, and adeduplication logic from a client; receive the format logic, thesemantic logic, and the deduplication logic from the first clientdevice; store the format logic, the semantic logic, and thededuplication logic in a data structure; present a second user interfaceto a second client device, wherein the second user interface isconfigured to receive a set of rules from the second client device;receive the set of rules from the second client device; populate aspreadsheet with the set of rules; execute the set of rules from thespreadsheet; present a third user interface to a third client device,wherein the third user interface includes a reflexive questionnaireincluding a set of questions generated based on the set of rules;receiving, by the server from the third client device, one or moreanswers to the set of questions of the reflexive questionnaire, the oneor more answers input by a user; send a query to a data source as thereflexive questionnaire is presented on the third user interface,wherein the query comprises the one or more answers and is triggeredbased on the set of rules, wherein the data source is remote from theserver; receive a result to the query from the data source; translatethe result based on the format logic, the semantic logic, and thededuplication logic from the data structure; and update the reflexivequestionnaire based on the result as translated.
 12. The system of claim11, wherein the data structure is a single data structure.
 13. Thesystem of claim 11, wherein the first client and the second client areinternal to a network containing the server, wherein the third client isexternal to the network.
 14. The system of claim 11, wherein the datasource includes a plurality of databases configured according to aplurality of schemas, wherein the result includes a plurality ofresults, wherein the schemas are different from each other, wherein theresults at least partially overlap each other.
 15. The system of claim11, wherein the data source includes a plurality of databases configuredaccording to a plurality of schemas, wherein the result includes aplurality of results, wherein the schemas are different from each other,wherein the results do not overlap each other.
 16. The system of claim11, wherein the server is further configured to: present an actionrecommendation to the third client based on a set of answers notsatisfying the threshold.
 17. The system of claim 11, wherein the serveris further configured to: send a status message to the third clientbased on the set of answers satisfying a threshold.
 18. The system ofclaim 11, wherein at least one of the format logic, the semantic logic,or the deduplication logic is configured for text processing.
 19. Thesystem of claim 11, wherein the data structure is a plurality of datastructures.
 20. The system of claim 19, wherein the data structuresincludes a first data structure, a second data structure, and a thirddata structure, wherein the first data structures the format logic,wherein the second data structure stores the semantic logic, wherein thethird data structure stores the deduplication logic.